Home » SQL & PL/SQL » SQL & PL/SQL » Cannot commit in a trigger
Cannot commit in a trigger [message #164] Tue, 22 January 2002 21:11 Go to next message
Vasea
Messages: 5
Registered: January 2002
Junior Member
I need a algoritm to resolve this problem.
Re: Cannot commit in a trigger [message #167 is a reply to message #164] Wed, 23 January 2002 05:04 Go to previous messageGo to next message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
Hi,

can you explain little more.

why u want ot commit in trigger ?
what u want to do ?
can u give an example?

cheers
pratap
Re: Cannot commit in a trigger [message #177 is a reply to message #164] Thu, 24 January 2002 04:39 Go to previous message
Ajay Gandhi
Messages: 14
Registered: January 2002
Junior Member
THis is asking for trouble. A Bad design. Doing a commit in trigger is like opening a can of worms to resolve various data integrity issues.

Previous Topic: Selecting records from tables in separate Oracle Databases
Next Topic: variable in implicit cursor problem
Goto Forum:
  


Current Time: Mon Aug 02 10:53:46 CDT 2021