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.
store procedure
Moderators: chulett, rschirm, roy
This has been discussed just yesterday.
viewtopic.php?t=105317&highlight=stored+procedure
Search the forum you will get more!
viewtopic.php?t=105317&highlight=stored+procedure
Search the forum you will get more!
Narasimha Kade
Finding answers is simple, all you need to do is come up with the correct questions.
Finding answers is simple, all you need to do is come up with the correct questions.
-
- Participant
- Posts: 5
- Joined: Wed Aug 16, 2006 10:58 am
Got this from the STP documentation
You could read more from there.
Hope that helps.
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.
Hope that helps.
Narasimha Kade
Finding answers is simple, all you need to do is come up with the correct questions.
Finding answers is simple, all you need to do is come up with the correct questions.