Re: Delete trigger deletes an entire table
Omar Crea Wrote:
-------------------------------------------------------
>
> but it erase all records in the ProcFamClass
> table!
>
You asked it to do that
delete from ProcFamClass where ProcFamClass.proc_id = proc_id;
where procid = procid always evaluates to true, so this command always deletes all records.
Subject
Views
Written By
Posted
2613
March 13, 2012 07:33PM
Re: Delete trigger deletes an entire table
1211
March 14, 2012 03:24PM
1085
March 15, 2012 09:21AM
970
March 16, 2012 11:15AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.