Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> trapping pl/sql errors with line numbers

trapping pl/sql errors with line numbers

From: Jeff Smith <jsmit234>
Date: Thu, 19 Jun 2003 08:19:43 -0400
Message-ID: <bcs9ov$svi6@eccws12.dearborn.ford.com> 





I have been searching docs and sites but no luck.



When catching unhandled errors in PL/SQL procedures using 8.1.7, is there
any internal function that can record the line number that failed?



If caught in an WHEN OTHERS THEN exception block, we record the SQLCODE, but
it would be nice to know what line failed. Having the line from all_source
would make it easier to debug.



Regards,


Jeff
Received on Thu Jun 19 2003 - 07:19:43 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US