2 Replies Latest reply: May 23, 2013 6:14 AM by Mike-Matthews-Oracle RSS

    How to call Oracle Stored Procedure using EDQ

    Bala Govi
      Can someone tell me how to use Oracle Stored Procedure call in EDQ, sample scripts/steps will be really helpful. Thanks!
        • 1. Re: How to call Oracle Stored Procedure using EDQ
          Craig Botha (IBP)
          Hi

          We have done this by using an external task to call a bat file (we use a windows environment). The external task is then called from an EDQ Job.

          The bat file contains a SQLPlus call that executes the SP:

          sqlplus -l [USER]/[PWD]@[Connect_Identifier] @"[FileName].sql"

          Hope this helps
          Regards
          Craig
          • 2. Re: How to call Oracle Stored Procedure using EDQ
            Mike-Matthews-Oracle
            It is also possible to do this using a custom processor in EDQ. The processor needs to do something very similar to the external task above (opens a DB connection, authenticates, runs a stored procedure).

            If you need this, please talk us through the use case so we can determine if it is the best fit. In some ways, an external task is better as logically a stored procedure call is normally divorced from any process logic in EDQ.

            Regards,

            Mike