Oracle procedures and functions usage in DS

irajasekharhexa · Post by **irajasekharhexa** » Tue Jan 09, 2007 5:57 am

Hi,

Can we use Oracle Procedures and functions in Datastage.

kumar_s · Post by **kumar_s** » Tue Jan 09, 2007 6:08 am

Yes in stored procedure and queries that been called by Datastage.

DSguru2B · Post by **DSguru2B** » Tue Jan 09, 2007 7:53 am

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.

ray.wurlod · Post by **ray.wurlod** » Tue Jan 09, 2007 1:41 pm

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.