OraFAQ Forum: SQL & PL/SQL » Oracle error code

Home » SQL & PL/SQL » SQL & PL/SQL » Oracle error code

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle error code [message #151039]

Mon, 12 December 2005 14:59

tuthuduc
Messages: 1
Registered: December 2005
Location: Minnesota

Junior Member

Does any know where I can find documentation on how each of the error codes works ( -20001 to -20999).
Thanks

Report message to a moderator

Re: Oracle error code [message #151040 is a reply to message #151039]

Mon, 12 December 2005 15:19

Art Metzer
Messages: 2480
Registered: December 2002

Senior Member

Error codes that fall in the range from -20000 to -20999 are user-defined, and therefore will vary from application to application.

For what the standard errors mean, look here.

Report message to a moderator

Re: Oracle error code [message #151041 is a reply to message #151039]

Mon, 12 December 2005 15:28

wpaillan
Messages: 35
Registered: March 2005
Location: Santiago - Chile

Member

HI
HERE PLENTY OF INFORMATION EXISTS
http://www.oracle.com/pls/db92/db92.homepage

BUT ALSO THAT RANGE OF ERRORS IS MANIPULABLE
LIKE THE FOLLOWING ERROR, YOU ARE LIKE A WILDCARD
FOR EXAMPLE IN A TRIGGER

IF CONTADOR > 0 THEN
RAISE_APPLICATION_ERROR (-20501, 'Error: Existe SOLAPAMIENTO entre rangos para las fechas dadas DE VIGENCIA.');
END IF;

Report message to a moderator

Re: Oracle error code [message #155245 is a reply to message #151039]

Thu, 12 January 2006 23:30

Kees Barneveld
Messages: 3
Registered: January 2005

Junior Member

Hi,

Lots of error codes explained with some more details/examples at http://www.dbmotive.com/oracle_error_codes.php

Regards,

Kees

[Updated on: Thu, 12 January 2006 23:36]

Report message to a moderator

Previous Topic:	dbms_trace?
Next Topic:	PARTITION CAN NOT BE SPLIT ALONG THE SPECIFIED HIGH BOUND...

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 20:28:15 CDT 2024