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!

Dynamic SQL in Triggers

81928Nov 7 2001

Does anyone know if it is possible to have dynamic SQL statements
within a trigger.
for example,

sql_str := 'insert into log_'||table_name||'values
(''A'',:new.descr)';
execute immediate sql_str;

I kept on getting an internal error as follows
ORA-00600: internal error code, arguments: [15212], [3], [], [],
[], [], [], []
ORA-06512: at "CDC.TG_BI_COMPANY_C", line 30
ORA-04088: error during execution of trigger 'CDC.TG_BI_COMPANY_C'

Thanks in advance

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 11 2001

Added on Nov 7 2001

5 comments

292 views