Home » Developer & Programmer » Forms » FRM-40735 : WHEN-BUTTON-PRESSED TRIGGER RAISED UNHANDLED EXPCEPTION ORA-00001.
FRM-40735 : WHEN-BUTTON-PRESSED TRIGGER RAISED UNHANDLED EXPCEPTION ORA-00001. [message #245101] Fri, 15 June 2007 03:08 Go to next message
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 #245111 is a reply to message #245101] Fri, 15 June 2007 03:40 Go to previous messageGo to next message
wency
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

ORA-00001 unique constraint table.column violated
Cause: An update or insert statement attempted to insert a duplicate key.

Click Help then display error to see the specific error.
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 Go to previous message
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.
Previous Topic: DATE and Time disappear when Enter query
Next Topic: HOW TO RESTRICT
Goto Forum:
  


Current Time: Mon Dec 05 08:41:02 CST 2016

Total time taken to generate the page: 0.06075 seconds