Can someone help me, how to call oracle stored procedure from datastage.
Re: Call Stored Procedure2005-06-09T18:44:45ZThis is the accepted answer. This is the accepted answer.Newer versions of DataStage have a Stored Procedure stage, which gives you way more options. Otherwise, you just issue the 'call' statement in the Before Sql tab of an OCI stage.
Re: Call Stored Procedure2006-02-01T14:38:47ZThis is the accepted answer. This is the accepted answer.In the stored procedure stage, there are default proc code and message that are returned by the output of the stored procedure stage. You can send that to the Transformer stage that in turn sends it to a sequetial file. The file will serve as the log file for the stored procedure.