Truncate table inside trigger(Urgent help needed)

[jith87]

hi,
how do you truncate a table inside a trigger(plsql) if the table size is more than 1000 records???
regards,
jith

[debasisdas]

Try to use native dynamic sql (EXECUTE IMMEDIATE)

also mark the trigger as pragma autonomous_tran saction;

[gintsp]

Try to use native dynamic sql (EXECUTE IMMEDIATE)

also mark the trigger as pragma autonomous_tran saction;

Just remember that pragma autonomous_tran saction and truncate is very dangerous tool. In case your main transaction is rolled back, truncated table will remain truncated anyway.

Gints Plivna

http://www.gplivna.eu