| FRM-40735 : WHEN-BUTTON-PRESSED TRIGGER RAISED UNHANDLED EXPCEPTION ORA-00001. [message #245101] |
Fri, 15 June 2007 03:08  |
seeahead
Messages: 10
Registered: May 2007
|
Junior Member |
|
|
Hi All,
on When-button-pressed event i have written this code
IF :START_DATE IS NULL THEN
MESSAGE('Please Enter Start Date');
MESSAGE(' ');
ELSE
Order_orion_eims_test2(:START_DATE,sysdate);
order_update_orion_eims_test2(:START_DATE,sysdate);
MESSAGE('Records Successfully Transferred');
MESSAGE(' ');
END IF;
But I am getting this error message.
I am calling two procedures in this code.
FRM-40735 : WHEN-BUTTON-PRESSED TRIGGER RAISED UNHANDLED EXPCEPTION ORA-00001.
Thanks
|
|
|
|
|
|
| Re: FRM-40735 : WHEN-BUTTON-PRESSED TRIGGER RAISED UNHANDLED EXPCEPTION ORA-00001. [message #245189 is a reply to message #245111] |
Fri, 15 June 2007 07:27  |
kamran.it
Messages: 265
Registered: September 2005
Location: Karachi
|
Senior Member |
|
|
Error: ORA-00001: unique constraint (constraint_name) violated
Cause: You tried to execute an INSERT or UPDATE statement that has created a duplicate value in a field restricted by a unique index.
Action: The options to resolve this Oracle error are:
1. Drop the unique constraint
2. Change the constraint to allow duplicate values
3. Modify your SQL so that a duplicate value is not created
If you are not sure which unique constraint was violated, you can run the following SQL:
select distinct table_name
from all_indexes
where index_name = 'CONSTRAINT_NAME';
In our example (see picture above), our constraint name would be SYS_C002459 and we would execute the following SQL:
select distinct table_name
from all_indexes
where index_name = 'SYS_C002459';
This would return the name of the table whose unique constraint we violated.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
