Re: trouble with ORA-04094

From: Gunjan <gunjansahay_at_yahoo.com>
Date: 1 Apr 2002 05:28:17 -0800
Message-ID: <15921bee.0204010528.3e1f252d@posting.google.com>

this is the trigger

CREATE OR REPLACE TRIGGER del_login_id before DELETE ON userinfo fOR EACH ROW
BEGIN

	delete lst_pg where login_id = :old.login_id;
	delete user_track where login_id = :old.login_id;
	delete hrspent where login_id = :old.login_id;
	delete bookmark where login_id = :old.login_id;
	delete user_task where login_id = :old.login_id;
	delete user_sugg where login_id = :old.login_id;

END;
/

and this is the error that is thrown up

Microsoft OLE DB Provider for ODBC Drivers error
'80004005'

[Oracle][ODBC][Ora]ORA-04094: table
SYSTEM.LST_PG is constraining, trigger may not modify it ORA-06512: at
"SYSTEM.DEL_LOGIN_ID", line 2 ORA-04088: error during execution of trigger
'SYSTEM.DEL_LOGIN_ID'
this works fine with oracle 8.1.5 but is given this error with Oracle8.0.5
as suggested by some i cannot upgrade to the newer version...i have to work on what is available and the real system has to be on 8.0.5 Received on Mon Apr 01 2002 - 07:28:17 CST