From sawmillert@state.mi.us Wed, 16 May 2001 06:36:03 -0700 From: "Tim Sawmiller" Date: Wed, 16 May 2001 06:36:03 -0700 Subject: Re: Oracle error -20001 Message-ID: MIME-Version: 1.0 Content-Type: text/plain Well that was a naughty thing for them to do... >>> bill@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@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@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@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@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).