Re: ORA-20002

In article <9b1af8$p6r$1_at_news.uni-leipzig.de>, Jan Schäfer <schaefer_at_kksl.uni-leipzig.de> writes:
>Hi,
>
>I got the error message ORA-20002 but can't find this error number in the
>docs.
>Does anyone knows this error number?
>
>Thanks,
>
>Jan
>
>

I no longer remember the exact range but Oracle Errors in the range 2000 - 20999 are reserved for use by application developers to raise application errors using the raise_application_error routine from stored pl/sql routines.  In other words your application code has detected a condition that it considers to be an error and issued a message. The programmer should have also made use of the sqlerrm variable to pass back a text message.

Scan your application source for the 20002. Hopefully you will not find several of them or have a text message to help identify the code where the error was detected. The cause of the problem may or may not be related to an Oracle problem depending on the application developer.

If this is from canned code then you system documentation should have a list of error conditions else you will have to call the product vendor.

• Mark D Powell --
  • Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web ----- http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups NewsOne.Net prohibits users from posting spam. If this or other posts made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net