Home » SQL & PL/SQL » SQL & PL/SQL » update record using Trigger from the same table during insertion (oracle8.0)
update record using Trigger from the same table during insertion [message #381545] Sun, 18 January 2009 00:29 Go to next message
bamugan81
Messages: 4
Registered: December 2008
Location: INDIA - CHENNAI
Junior Member
I needs to update a field of a table, when a record is insert into that table itself by using trigger on insert

The error thrown is 'mutating error occurs'.

please help
Re: update record using Trigger from the same table during insertion [message #381549 is a reply to message #381545] Sun, 18 January 2009 01:00 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Normal and expected behaviour.
Plesae search before posting.

Regards
Michel
Re: update record using Trigger from the same table during insertion [message #381551 is a reply to message #381545] Sun, 18 January 2009 01:02 Go to previous messageGo to next message
Littlefoot
Messages: 20895
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This is one of the most popular questions; please, search the board.
Re: update record using Trigger from the same table during insertion [message #381552 is a reply to message #381545] Sun, 18 January 2009 01:08 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
bamugan81 wrote on Sun, 18 January 2009 07:29

The error thrown is 'mutating error occurs'.

NO!
The error is NOT 'mutating error occurs'.

If you want to find a solution (or want us to help you), you need to quote the exact message. Especially if you put quotes around them, it implies it is the literal error you got.
Previous Topic: Predefined Exceptions
Next Topic: filter oder record on tacle (merged 3)
Goto Forum:
  


Current Time: Mon Dec 05 15:17:43 CST 2016

Total time taken to generate the page: 0.11157 seconds