Re: Exception Handling!!

princevictor.moses_at_gmail.com wrote:

> I have a function which contains a collection of select and insert
>statements and I am also able to handle the exception and get the error
>code and error message using SQLCODE and SQLERRM respectively. But the
>problem is I am not able to figure out in exactly in which line or with
>which column the exception occurs. I s there is any method avalable for
>getting the detailed error message.

I can think of a couple fairly simple ways to do this:

1. Use nested annoymous blocking to trap EXCEPTIONS. [1]
2. Use DBMS_OUTPUT.put_line in the EXCEPTION handler.

[1]: Putting SELECT and INSERT statements in FUNCTIONs and PROCEDUREs

     is a good way too. Received on Wed Dec 20 2006 - 12:53:20 CST