Oracle Database Discussions

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 log sql text causing the error?

deniskaJan 11 2016 — edited Jan 12 2016

Hi, everybody.

I have pl/sql package with an error handling procedure using AUTONOMOUS_TRANSACTION.

I use SQLCODE and SQLERRM functions to get error code and description.

But also i want to log sql text caused the exception.

Is there any way to get it?

DB versions: 10g, 11g.

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 9 2016

Added on Jan 11 2016

#general-database-discussions

8 comments

1,892 views