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 Error

Raise Error

From: Chintu <agarwalp_at_eeism.com>
Date: Thu, 30 Aug 2007 00:48:47 -0700
Message-ID: <1188460127.258564.23980@r34g2000hsd.googlegroups.com>


I am trying to raise a simple error in a trigger...But apart from my error it also displays two other errors. ORA - 6512 at line 10
and ORA 04088 : error during execution of trigger

My trigger code is

CREATE OR REPLACE TRIGGER CBS_OWNR.BATCHJOBS_TRIG_CHKGROUPNAME   BEFORE INSERT OR UPDATE OF TOGROUP ON
CBS_OWNR.BILLINGBATCH_BATCHJOBS
  FOR EACH ROW WHEN (NEW.TOgroup IS NOT NULL)

	DECLARE
		NUM_RECS NUMBER;
		FINAL_GROUP VARCHAR2(30);
		E_INVALID_GROUP EXCEPTION;
	BEGIN
		SELECT COUNT(*) INTO NUM_RECS FROM CBS_OWNR.BILLINGBATCH_EMAILGROUPS
WHERE GROUPNAME=:NEW.TOgroup;   --line 10
		IF NUM_RECS = 0 THEN

				:NEW.TOgroup:=NULL;
				RAISE_APPLICATION_ERROR(-20901, 'Group Does not Exist');
		END IF;

	END;
Received on Thu Aug 30 2007 - 02:48:47 CDT

Original text of this message

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