Oracle and DataStage

jman · Post by **jman** » Thu Jun 09, 2005 2:13 pm

How can I use the Oracle function DBMS_APPLICATION_INFO.SET_MODULE(...) In a DataStage OracleOci8 Stage???

Or maybe somebody know another why to use this function in DataStage.

Thanks in advance.

Jman

ray.wurlod · Post by **ray.wurlod** » Thu Jun 09, 2005 3:16 pm

The OCI stage only uses SQL. So, if you can specify how you'd use it in SQL, you can use it in the OCI stage. Presumably as a "before" command rather than every row.

chulett · Post by **chulett** » Thu Jun 09, 2005 4:10 pm

It's a procedure, so you'd need to call it directly in the Before (or After) SQL tab. Search the forum for examples of using Stored Procedures with the OCI stages.

wdudek · Post by **wdudek** » Mon Jun 13, 2005 11:50 am

In the before (or after) tab put the following line

Code: Select all

 CALL DBMS_APPLICATION_INFO.SET_MODULE(...)

If CALL doesn't work try execute, but for some reason I think datastage likes call better. I tried looking for an example of how we do this but couldn't find one.

jman · Post by **jman** » Tue Jun 21, 2005 8:18 am

Thanks to all

jman

elavenil · Post by **elavenil** » Wed Jun 22, 2005 9:59 am

Stored procedure can be called from Before/After tabs available in OCI stage.

Regards
Saravanan