Page 1 of 1
Oracle procedures and functions usage in DS
Posted: Tue Jan 09, 2007 5:57 am
by irajasekharhexa
Hi,
Can we use Oracle Procedures and functions in Datastage.
Posted: Tue Jan 09, 2007 6:08 am
by kumar_s
Yes in stored procedure and queries that been called by Datastage.
Posted: Tue Jan 09, 2007 7:53 am
by DSguru2B
There is also a Stored Procedure Stage in versionis 7.5.1 and higher which can execute stored procedures. It can also be invoked in the before/after sql tab of OCI stage.
Posted: Tue Jan 09, 2007 1:41 pm
by ray.wurlod
Oracle functions are used within SQL queries. You can put them into the Derivation column in the Columns grid when selecting, or in user-defined SQL.