Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> raise_application_error in before delete trigger.

raise_application_error in before delete trigger.

From: Tim Belding <Tim_Belding_at_Dell.com>
Date: Wed, 16 May 2001 10:59:10 -0500
Message-ID: <9du84g$219e$1@galaxy.us.dell.com> 






Hi,



Can you use this function in a trigger to stop an unwanted deletion?



It throws the error we define, but also some Oracle errors as well:

ORA-20001: Cannot delete record because of status.
ORA-06512: at "RMS_DATA.JIA_STATUS_CHECK", line 30
ORA-04088: error during execution of trigger 'RMS_DATA.JIA_STATUS_CHECK'





If not how would you stop a deletion from occurring in a trigger?
Received on Wed May 16 2001 - 10:59:10 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US