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
ataufique
Messages: 79
Registered: November 2006
Member
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
wency
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: Fri Dec 09 04:23:37 CST 2016

Total time taken to generate the page: 0.08038 seconds