Hi all
is there any view that I can look in to see what are all the user defined error numbers??????????? So that I dont over write something already in use..
Thanks in advance
Printable View
Hi all
is there any view that I can look in to see what are all the user defined error numbers??????????? So that I dont over write something already in use..
Thanks in advance
I don't think there is, but you could query the user_source view ...
Code:SQL> select * from user_source where upper(text) like '%EXCEPTION_INIT%'
2 /
NAME TYPE LINE
------------------------------ ------------ ----------
TEXT
--------------------------------------------------------------------------------
ETL PACKAGE BODY 378
pragma exception_init(l_index_mismatch,-14098);