late binding Oracle Trigger

From: Vabs <rajatbsr_at_gmail.com>
Date: Thu, 17 Apr 2008 05:32:30 -0700 (PDT)
Message-ID: <8aa4b5c3-c34b-4dd8-af89-8013de32e5e2@f63g2000hsf.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:30 CDT

Original text of this message