I have been searching for an example of how to pass the output results into a log file or inserting into a log table.
How do you capture the output being created?
Example - delete from employee table where employee_status = '4';
Output results - '34 rows deleted'
I want to capture the output result - '34 rows deleted' and either put this in a log file or insert into a log table.
This would be done within a Oracle procedure only. (Oracle 11g)
I have the procedure written and works fine, just that I would like to add additional code (utl_file or anything else)
to capture these output results and insert these into a log file or table.