Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> 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)
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 CST