Topic
  • 4 replies
  • Latest Post - ‏2006-02-01T14:38:47Z by SystemAdmin
SystemAdmin
SystemAdmin
332 Posts

Pinned topic Call Stored Procedure

‏2005-06-09T14:51:04Z |
Hi,

Can someone help me, how to call oracle stored procedure from datastage.

Thanks
Ravi
Updated on 2006-02-01T14:38:47Z at 2006-02-01T14:38:47Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    332 Posts

    Re: Call Stored Procedure

    ‏2005-06-09T18:44:45Z  
    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.
  • SystemAdmin
    SystemAdmin
    332 Posts

    Re: Call Stored Procedure

    ‏2005-06-10T12:48:53Z  
    Thanks for your help. Are there any datastage variables using which i can capture oracle error messages (SQLCODE, SQLERRM)
  • SystemAdmin
    SystemAdmin
    332 Posts

    Re: Call Stored Procedure

    ‏2005-06-10T19:33:49Z  
    From the Stored Procedure? In the Before SQL tab? Nope.
  • SystemAdmin
    SystemAdmin
    332 Posts

    Re: Call Stored Procedure

    ‏2006-02-01T14:38:47Z  
    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.