| SQLCODE = 2122 [message #96970] |
Thu, 04 October 2001 08:29  |
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  |
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
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
