Re: List User Defined Exception Numbers?

"Anurag Varma" <avdbi_at_hotmail.com> wrote:

>
>"Jim McMahon" <jp_mcmahon_at_hotmail.com> wrote in message news:4098120d.344818433_at_news.charter.net...
>> Does anyone know whether it is possible to list user defined exception
>> numbers that may be defined within the triggers, procedures, and
>> functions defined under a given schema? Are they stored in some sort
>> of internal table when the entities are compiled that could be
>> queried?
>>
>> What I'd like to do is list all used error numbers so that when I
>> write a new function or trigger and raise a newly defined application
>> error I can ensure the number is unique. The functions and procedures
>> under the schema would all be signalling the errors via
>>
>> raise_application_error(error_number, message[, {TRUE | FALSE}]);
>>
>> where error_number is a negative integer in the range -20000 .. -20999
>> and message is a character string up to 2048 bytes long.
>>
>> If I can't get to the error numbers directly, is there an internal
>> table of object source I could dump out and run a grep tool against to
>> list all occurences of "raise_application_error" to find the numbers
>> that have been previously used ?
>> Being ordinary and nothing special is a full-time job.
>> jp_mcmahon_at_hotmail.com (Jim McMahon in real life)
>
>
>is user_source / all_source / dba_source what you are looking for?
>
>Anurag
>
>

Originally I was hoping for something to find the used application error codes only, but yes, I think user_source is what I was looking for as an alternative. I'll be able to verify that later today at work.

Being ordinary and nothing special is a full-time job. jp_mcmahon_at_hotmail.com (Jim McMahon in real life) Received on Thu May 06 2004 - 04:31:26 CDT