store procedure

Poonam Singh · Post by **Poonam Singh** » Tue Nov 21, 2006 11:38 am

Hi

I am trying to create a job to run the oracle procedure from datastage.

Oracle procedure have two parameters ymd, p_return_code.
ymd is date like 20061115 and p_return_code is null.
I have datastage version 7.5

Please help me to accomplish this. I am new in store call procedure.

narasimha · Post by **narasimha** » Tue Nov 21, 2006 11:48 am

This has been discussed just yesterday.

viewtopic.php?t=105317&highlight=stored+procedure

Search the forum you will get more!

Poonam Singh · Post by **Poonam Singh** » Tue Nov 21, 2006 12:14 pm

but how I can pass the parameters when I have "source" in syntax tab in
procedure type

narasimha · Post by **narasimha** » Tue Nov 21, 2006 12:36 pm

Got this from the STP documentation

Code: Select all

Source. Source procedures emulate an SQL SELECT statement and use the column meta data as output parameters to read from the database. They have only an output link.

You could read more from there.
Hope that helps.