Triggers

How can i reference variables if i must have statement level trigger
I am writing an enty to log table everytime delete, update or insert happends and if i do ROW level i can reference :NEW and :OLD, but then i get entry for each column and all i want is per each statement. But it gives me error bad binding if i do statement level and reference :NEW or :OLD
What do i do??
Help please
Thanks

KG

Comments

  • : How can i reference variables if i must have statement level trigger
    : I am writing an enty to log table everytime delete, update or insert happends and if i do ROW level i can reference :NEW and :OLD, but then i get entry for each column and all i want is per each statement. But it gives me error bad binding if i do statement level and reference :NEW or :OLD
    : What do i do??

    What are you trying to do? What is your log supposed to contain?
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

In this Discussion