Home » RDBMS Server » Server Administration » Database trigger
Database trigger [message #369649] Thu, 03 February 2000 23:14 Go to next message
stant_98
Messages: 4
Registered: February 2000
Junior Member
I have a problem with before update row trigger.
I get a mutating table error.I read up a bit on pos. solution.
Can anyone PLEASE POST SOME examples of how I can implement this
using both row-level and a statement level trigger along with a temp table that would store changed values from the original table.

ANY HELP AT ALL IS REALLY APPRECIATED!

THANKS!
Re: Database trigger [message #369650 is a reply to message #369649] Fri, 04 February 2000 10:07 Go to previous message
Shaik
Messages: 3
Registered: February 2000
Junior Member
HAI
MUTATAING ERROR COMES WHEN YOU ARE TRYING TO ACCESS THE SAME TABLE AND MAKE CHANGES IN
SAME TABLE WHEN THE TRIGGER IS RAISED ON THE TABLE
GIVES YOU THIS ERROR
AND THE DEFAULT STATUS OF TRIGGER IS STATEMENT LEVEL AND IT WILL FOR EVEN A SINGLE ACTION ALSO
YOU CAN MAKE USE OF TRIGER TO STORE
THE CHANGES IN A TEMP TABLE
SUPPOSE IF YOU HAVE EMP TABLE
AND WANT TO STORE ALL OLD VALUES
YOU CAN MAKE USE OF BIND VARIABLES
AVILABLE IN TRIGGERS SUCH AS
:OLD TO STAORE OLD VALUE
:NEW TO STORE NEW VALUE

GO THOUGH ORACLE COMMPLETE REFFERENCE
FOR EXAMPLES AND USAGE OF TRIGGERS
I THINK THIS WILL HELP YOU
BYE
SHAIK MASTHAN
Previous Topic: MULTISELECT
Next Topic: Re: Creating an ASCII file (line size -- 20000 chars) in PL/SQL
Goto Forum:
  


Current Time: Fri Oct 30 03:19:33 CDT 2020