AnsweredAssumed Answered

Can you run PL/SQL with the SQL job?

Question asked by Brett_Barnhart_453 on Jan 16, 2014
Latest reply on Jan 22, 2014 by Brett_Barnhart_453

I'm getting closer to getting the Oracle DB Agent and connections set-up. However, it looks like I can only run select, updates, etc.

I want to call a database procedure. I was hoping that the SQL job would be able to pass and capture the various input/output parameters in a nice graceful way..  but it doesn't look like that is the case?

Can anyone verify if the SQL Job allows what I am trying to achieve or should I continue to use a Unix job with SQLplus?

If you are familiar with Oracle EBS, think concurrent requests..  Where the first parameter is status_code, 2nd is Status_message, then you have input parameters. If the PL/SQL returns anything other then a 0, it is a warning or error, etc.

Outcomes