Answer Detail: RE: How to find error line of a package at run time

GeekInterview.com > Interview Questions > Oracle > PL/SQL

Print |

Question: How to find error line of a package at run time

Answer: How can the error line can be identified for a package at run time ?

September 09, 2008 04:19:39	#2
tripathi.atul	Member Since: September 2008 Total Comments: 4
RE: How to find error line of a package at run time
Starting from Oracle 10G we can use DBMS_UTILITY.FORMAT_ERROR_BACKTRACE function to get the line from where the error originated.