Home » Infrastructure » Unix » SQLCODE = 2122
SQLCODE = 2122 [message #96970] Thu, 04 October 2001 08:29 Go to next message
Sebastián Acuña mejía
Messages: 1
Registered: October 2001
Junior Member
In Proc, when the program is in FETCH, that stament return the code's sqlcode 2122. Why it happend is?
very thank from Santiago city, CHILE

----------------------------------------------------------------------
Re: SQLCODE = 2122 [message #96997 is a reply to message #96970] Fri, 12 October 2001 15:30 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
on unix, type "oerr ora 1"

oracle>oerr ora 1
00001, 00000, "unique constraint (%s.%s) violated"
// *Cause: An update or insert statement attempted to insert a duplicate key
// For Trusted ORACLE configured in DBMS MAC mode, you may see
// this message if a duplicate entry exists at a different level.
// *Action: Either remove the unique restriction or do not insert the key
oracle>

on NT, query the database
http://www.orafaq.net/scripts/sql/oerr.txt

I can't find 2122

----------------------------------------------------------------------
Previous Topic: error:Ora-07217
Next Topic: Re: ORA-01012
Goto Forum:
  


Current Time: Fri Mar 29 09:17:25 CDT 2024