Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
late binding Oracle Trigger
0 views
Skip to first unread message
Vabs
Apr 17, 2008, 8:32:30 AM4/17/08
to
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)
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...
bdbafh
Apr 17, 2008, 9:38:24 AM4/17/08
to
Check out the usage of the package dbms_sql
-bdbafh
news.verizon.net
Apr 17, 2008, 10:04:43 AM4/17/08
to
"Vabs" <raja...@gmail.com> wrote in message
news:8aa4b5c3-c34b-4dd8...@f63g2000hsf.googlegroups.com...
bad idea. If you don't know the column name then you have a problem. If
you are trying to avoid writing a lot of triggers then write a little
program that will create the triggers for you. If you are trying to write a
home made auditing system then use Oracle's native auditing.
Jim
0 new messages