Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Dynamically retrieve :NEW and :OLD values of a column in a trigger

455605Nov 7 2006 — edited Nov 9 2006
I am just wondering if this possible.

EXECUTE IMMEDIATE 'select :new.<columnname> from dual' INTO tempstr

where:
.<columnname> is a column of a table
tempstr is a local variable

I tried but it didn't work. You guys might have other idea to retrieve old and new values dynamically.


Thanks,
Baldwin
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 7 2006
Added on Nov 7 2006
7 comments
2,587 views