Deleting all table recs via trigger in runtime form

I am having some difficulty deleting all records from a table using a trigger in an Oracle Form. I am using Oracle Forms 5.

I tried using:
1) delete from filter_table;
(this causes the form to hang in runtime and eventually I have to kill
the task)
2) create a cursor to run over each record and use "DELETE_RECORD"
(this has the same affect as above)

• I don't think the PL/SQL in forms (DML?) allows me to use Truncate.

Do I need an 'Instead-of' Trigger?

Any advice would be greatly appreciated.

Richard W. Dowdy
richdow_at_thegrid.net
Client Development Leader
SAP/Oracle Help Desk Project Received on Thu Dec 10 1998 - 00:00:00 CET