store procedure
Posted: 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.
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.