| ORA-00001 [message #133519] |
Fri, 19 August 2005 07:41  |
VSPB
Messages: 27
Registered: August 2005
|
Junior Member |
|
|
THIS ERROR OCCURS WHEN ANY UNIQUE KEY IS VIOLATED. IN MY FORM I HAVE USED ON-ERROR TRIGGER WHICH FIRES FOR DUPLICATE ENTRY. BUT THERE I HAVE USED FORM ERROR. FRM-40508. BUT I WANT TO SHOW THE ERROR MESSAGE FOR ORA-00001 IF ANY DUPLICATE ENTRY IS MADE IN THE FORM. I.E. IF ANY UNIQUE IS VIOLATED IN THE FORM...
PLEASE HELP...
|
|
|
|
| Re: ORA-00001 [message #133524 is a reply to message #133519] |
Fri, 19 August 2005 07:58  |
kiran
Messages: 503
Registered: July 2000
|
Senior Member |
|
|
You can keep an exception handling.
something like following.
Exception
When DUP_VAL_ON_INDEX Occurs then
Message('Inserting duplicate records');
Message();
I haven't tested this , check out if it can be useful.
--Kiran.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
