Re: Oracle error -20001

Well that was a naughty thing for them to do...

>>> bill_at_datacraft.com 05/15/01 08:25PM >>>
> Unless things have changed, 20000 thru 20999 are user specified error numbers, not
>generated by Oracle.

It turns out that some of the developers at Oracle have been using these error numbers as well. If you're
on a unix box, try this:

    grep -i '\-20[0-9][0-9][0-9]' $ORACLE_HOME/rdbms/admin/*

...I see about 200 uses of this error range by Oracle. A few examples:

utlpwdmg.sql:     raise_application_error(-20001, 'Password same as user');
utltcp.sql:  end_of_input_errcode     CONSTANT PLS_INTEGER:= -20001;
recover.bsq:        raise_application_error(-20001, 'Database not found');

A good application developer will include a descriptive message to go along with that error number...if you
can't get to the source code, maybe see if there is a way to enable more logging features so you can see
the error text.

Good luck
Bill

--

______________________________________________
http://www.datacraft.com/    http://plnet.org/ 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Bill Pribyl
  INET: bill_at_datacraft.com 

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tim Sawmiller
  INET: sawmillert_at_state.mi.us

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).