Howdy, Stranger!

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

Categories

Triggers

katukhakatukha Member Posts: 10
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

  • infidelinfidel Member Posts: 2,900
    : 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.