Re: late binding Oracle Trigger
From: bdbafh <bdbafh_at_gmail.com>
Date: Thu, 17 Apr 2008 06:38:24 -0700 (PDT)
Message-ID: <6ed01e98-ef5f-4cdb-91c2-e3f2cae80523@x41g2000hsb.googlegroups.com>
Date: Thu, 17 Apr 2008 06:38:24 -0700 (PDT)
Message-ID: <6ed01e98-ef5f-4cdb-91c2-e3f2cae80523@x41g2000hsb.googlegroups.com>
On Apr 17, 8:32 am, Vabs <rajat..._at_gmail.com> wrote:
> 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...
Check out the usage of the package dbms_sql
-bdbafh Received on Thu Apr 17 2008 - 08:38:24 CDT