DSXchange

Dear All,
we are using DS server edition here on our DW project
server is on the AIX machine and client is on the windows machine
oracle 10g database is on the AIX machine as well . We have created few procedure and want to call them with Stored Procedure Stage but whenever I go to import the stored procedure definition following error occurs

"Empty DSN: list returned from host 172.20.16.150"

how can i configure the DSN on my AIX machine
Please help me out
Regards

Have you configured the DataStage Server for Oracle yet? The process is documented in both the 'Plug-in Installation and Configuration Guide' and the OCI stage docs themselves.

Is this your only problem? Are you able to do other Oracle tasks like import plug-in metadata using an OCI stage or run a job with an OCI stage in it? If not, then see above.

You know, you don't have to pick the DSN from a list, you can always just type one in for it to use...

to import the procedure definition you need the DSN but u can simply put the procedure name in the procedure name field and then in the call simply say begin procedure name; end; and it will execute
one of my friend found the solution THANKS A LOT FOR THE HELP

You haven't solved your problem with importing the metadata. And of course it will execute without having to do that first, it just simplifies the setup of the stage when you've got a complex SP.

Indeed, DataStage will not be able to check that the number of columns in your design matches the number of arguments in the stored procedure, so is likely to generate a warning to this effect.