Oracle Trigger Late binding

From: Vabs <rajatbsr_at_gmail.com>
Date: Thu, 17 Apr 2008 05:32:01 -0700 (PDT)
Message-ID: <effa3549-1347-45c0-bf8e-2d2b2ff293f3@m73g2000hsh.googlegroups.com>

i want to use if(:new.column_name is not null) which works perfect... however my problem is that i want to set this column_name as a run time variable (as the table columns are not known to me)

I tried using a variable but oracle throws a PLS-00049 bad bind variable error.

Please help... Received on Thu Apr 17 2008 - 07:32:01 CDT

This message: [ Message body ]
Next message: fitzjarrell_at_cox.net: "Re: HowTo find out used (useful) and unused (usesless) indexes?"
Previous message: Andreas Mosmann: "HowTo find out used (useful) and unused (usesless) indexes?"
Next in thread: fitzjarrell_at_cox.net: "Re: Oracle Trigger Late binding"
Reply: fitzjarrell_at_cox.net: "Re: Oracle Trigger Late binding"
Reply: Ken Denny: "Re: Oracle Trigger Late binding"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message