Home » SQL & PL/SQL » SQL & PL/SQL » on insert trigger
on insert trigger [message #217699] Sun, 04 February 2007 22:09 Go to next message
Messages: 79
Registered: November 2006
I have a master-detail table..
in on insert trigger i have written the insert statement for parent table and then for child table like
insert into dept......
insert into emp..

it gives me error ora-00001..uniqueness error...whereas i dont have a unique check defined...

pls help...
Re: on insert trigger [message #217700 is a reply to message #217699] Sun, 04 February 2007 23:00 Go to previous message
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

Check your table, it has contraints and/or indexes violated.
Previous Topic: transfer data from deffirent versions
Next Topic: related to drop command
Goto Forum:

Current Time: Tue Jul 25 22:19:31 CDT 2017

Total time taken to generate the page: 0.07872 seconds