Hi all,
To call a oracle procedure we can use the Stored procedure stage,Like i need to call the Oracle function? how it is possible i will pass the value to the function from the file ???? I am using datastage 7X parallel..
Please Help me out......
Calling an Oracle Function
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 467
- Joined: Tue Mar 20, 2007 6:36 am
- Location: Chennai
- Contact:
As Craig points out, You can use it the same way you do in your SQL.
For instance you can have a database stage with this query:
IHTH
For instance you can have a database stage with this query:
Code: Select all
Select myschema.myfunction(myarguments...) from dual;
Minhajuddin
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
-
- Participant
- Posts: 17
- Joined: Mon Sep 10, 2007 3:24 am