triggers oracle 10g old / new values
Posted on 2012-03-20
i am trying to see if in oracle their is a quick way to get the entire row for old and new values.
I want the trigger to call a procedure, and i want to pass two variable to the procedure
1 would be the the old_row_values, the other would be the new row_values.
Creating the procedre with teh record data type is no problem, and I could assign each column of a record data type in the trigger.
But i wanted to know if there was something like
OLD_RECORD := :OLD row
NEW_RECORD := :NEW row
?? if not please elt me knwo and at least that will stop me going down a bad path