Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How I can determine which SQL statement triggered an Oracle error?

April 26, 2017determine Error Oracle sql triggered

0

Posted

How I can determine which SQL statement triggered an Oracle error?

1 Answer

0

Posted

You can generally look in the corresponding log or trace file to find out which SQL statement has triggered an error. If this is not possible in your particular case, you can activate a more precise logging process in Oracle for a specific error code (for example, tracing for ORA-00942 -> = 942): ALTER SYSTEM SET EVENTS = ‘ trace name errorstack forever, level 1’; If an SQL statement now triggers an error, Oracle creates a detailed trace file in the usertrace directory. This file includes, among other things, the triggering SQL statement.