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!

how to generate a log file from db procedure

1498181Mar 27 2014 — edited Mar 28 2014

i am writing a database procedure which calls gl_je_batches_pkg.delete_row(v.rowid,v.je_batch_id) api to delete GL batches. i have also made a concurrent program but need to generate a log file

showing the numbers of records deleted and the error records as well. how will i do it?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 25 2014
Added on Mar 27 2014
10 comments
10,960 views