Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How do I log the result of a script/ pl/sql query to a custom table?

User_GEMBHNov 22 2021 — edited Nov 23 2021

How might I go about logging the result of an automated sql script and or pl/sql procedure in oracle sql developer in a custom table?
I'd like to capture:
success or failure of the script/query, error code if present, date time of completion and the target table for insertion.
We are using stone branch to automate the jobs and can see each query result there, but cannot see a consolidated result of 12 daily scheduled jobs.

Comments

Post Details

Added on Nov 22 2021
7 comments
1,034 views