0

I executed a script in unix that called a function in oracle db. I didn't gave the logfile information for the unix script. Usually, when I run a script to call a db function, I give logfile for script and monitor the unix log file and know that if the function is still running or is done. Also, the logfile has information whether the function executed successfully or not.

I have following concerns, based on above situation:

  1. Can I monitor if the function is still running or not using oracle sql developer?
  2. Can I know if the funtion executed successfully in Oracle DB or not? If oracle saves a log of function execution and I could access that then it would be great.

Thank You

austin
  • 45
  • 1
  • 11
  • Do you actually mean function, or do you mean procedure? Functions are called as part of a query, procedures are called on their own with `EXECUTE`. – Mr. Llama Feb 11 '16 at 16:56
  • The unix script has following line to call the function: `exec :v_return_nbr := function(parameters);` – austin Feb 11 '16 at 16:58

1 Answers1

0

Yes, you can monitor if the function is still running by checking the session's status in v$session. See this answer for information on how: How to list active / open connections in Oracle?

As for what the execution result was... probably not.
The PL/SQL you executed won't directly appear in dba_audit_trail, but any queries it ran as part of execution might. The audit trail will show if the queries were successful or not, but it won't show the query results or the final result of the function execution.

Community
  • 1
  • 1
Mr. Llama
  • 20,202
  • 2
  • 62
  • 115