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...
