using same mySeq.nextVal to insert into two tables

[FALCONSEYE]

I am trying insert a PK as a FK to another table. Inside my trigger, I have:

 tmpTHID number;
 select mySeq.nextval into tmpTHID from dual;

 insert into tbl1 ( tmpTHID, .... )

 insert into tbl2 (id, tmpTHID, ... )

when i change something on tbl2, i get a tbl1 primary key constraint violated error. what can i do?

thanks in advance,

http://www.fuzzysiberians.com

 

[FALCONSEYE]

oops, it's called mySeq.currVal

http://www.fuzzysiberians.com

 

[SantaMufasa]

when i change something on tbl2

What, more precisely, do you mean by "when I change something"? May we see more of your actual code that involves code that exemplifies a "change"? (Seeing such will help us to better help you.)


Thanks,

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
“Beware of those that seek to protect you from harm or risk. The cost will be your freedoms and your liberty.”

 

[FALCONSEYE]

Sorry, it wasn't clear enough. The triggers fire on insert, delete or update.

http://www.fuzzysiberians.com

 

[Dagon]

I'm confused as to whether you are asking a question here or have already solved it. If the question is still live, there isn't enough information here to give a response. We'd need a bit more than a very small code fragment.

For Oracle-related work, contact me through Linked-In.