Re: Exception Handling!!

The simple way to identify where in the code a problem is occurring is to insert an I_AM_HERE variable in the code before every single SQL statement and before any long chunk of just pl/sql code.

v_statement := 10;
select sysdate from sys.dual;
v_statement := 20;
for c1 in ( select ..... ) loop
...

   v_statement := 30;
...

end loop;
v_statement := 40

Then in the error handler you append the v_statement value to the SQLERRM value.

HTH -- Mark D Powell -- Received on Fri May 19 2006 - 07:27:04 CDT