Calling an Oracle Function

[ithirak_17]

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......

[chulett]

Welcome.

How would you call an Oracle function outside of DataStage? The same answer applies inside a job.

[Minhajuddin]

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:

Code: Select all

Select myschema.myfunction(myarguments...) from dual;

IHTH

[ithirak_17]

Hello all,
The function will returns the value. so how i can handle that???

[chulett]

You select it as field in your source or lookup SQL.