Home » SQL & PL/SQL » SQL & PL/SQL » Oracle Trigger Error (Oracle 9i)
icon1.gif  Oracle Trigger Error [message #406379] Wed, 03 June 2009 13:55 Go to next message
elangodba
Messages: 6
Registered: October 2008
Location: Chennai
Junior Member
Hi all,

I have a critical situation. I have two servers and both have same structure. I have a trigger in both the server which will be fired when we insert into particular table. When the trigger is fired it will insert a row into another table.

But my problem is the trigger works fine with one server ie., inserts a row into another table in one server.
But in another it inserts two rows. I have no idea hos this happened. Any suggestions will be helpful.

Thanks in Advance.

Elango
Re: Oracle Trigger Error [message #406384 is a reply to message #406379] Wed, 03 June 2009 14:29 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Any suggestions will be helpful.

You have a bug in your code or your design, fix it.

Regards
Michel
Re: Oracle Trigger Error [message #406386 is a reply to message #406384] Wed, 03 June 2009 14:50 Go to previous messageGo to next message
elangodba
Messages: 6
Registered: October 2008
Location: Chennai
Junior Member
Thanks for your reply.


The code is just fine and it works properly in one server but not in another.
Re: Oracle Trigger Error [message #406389 is a reply to message #406386] Wed, 03 June 2009 14:57 Go to previous messageGo to next message
elangodba
Messages: 6
Registered: October 2008
Location: Chennai
Junior Member
Found the problem. Issue resolved. Thanks

[EDITED by LF: removed unnecessary quote]

[Updated on: Thu, 04 June 2009 02:06] by Moderator

Report message to a moderator

Re: Oracle Trigger Error [message #406399 is a reply to message #406389] Wed, 03 June 2009 16:42 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
let me guess - you changed the trigger name, so ended up with 2 copies that both fired.
Re: Oracle Trigger Error [message #406555 is a reply to message #406399] Thu, 04 June 2009 10:47 Go to previous messageGo to next message
elangodba
Messages: 6
Registered: October 2008
Location: Chennai
Junior Member
Hi ,

Thanks for your replies.

I had a duplicate schema which holds the same data as of original. and it hold the same trigger so when i tried to insert both the trigger got fired.

Re: Oracle Trigger Error [message #406561 is a reply to message #406555] Thu, 04 June 2009 11:21 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
if your system permissions are so open that you can create objects in schemas other than the one you are connected to - you open yourself up to a lot of heartburn as you're finding out. Believe me - I've been doing this for a long time.
Previous Topic: How to find out the user name or login name
Next Topic: Dynamic Using for Execute Immediate
Goto Forum:
  


Current Time: Sun Dec 11 02:20:02 CST 2016

Total time taken to generate the page: 0.10178 seconds