All Forums Database
ljdenning 4 posts Joined 02/13
28 May 2013
Stored Procedure error reporting

Does anyone know if there is a way to trap/display line numbers from stored procedures during execution errors (much in the way that a line number is displayed during a compile error)? I don’t see anything in any forum or documentation that indicates this capability exists (and for 7 years I haven’t heard of anything like this). I’ve studied error handling/diagnostics etc. and we could obviously improve error handling but this is an Oracle PL/SQL forklift of hundreds of SPs and the client is looking for the easy way out…

You must sign in to leave a comment.