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.