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?
  • Andre YoungAndre Young USAMember Posts: 0

    ______ ( http://forcoder.org ) free video tutorials and ebooks about | Visual Basic PHP JavaScript Scratch Objective-C C++ Swift PL/SQL Python Visual Basic .NET Ruby Perl MATLAB Go Java C# Delphi C R Assembly Hack Lisp D Fortran SAS Ada ABAP Transact-SQL ML Awk Alice Bash Lua COBOL Crystal LabVIEW Clojure Rust Julia Erlang Prolog Scala Dart Logo F# Kotlin VBScript Apex Scheme FoxPro |

Sign In or Register to comment.