Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> raise_application_error generates trace file
I've created a logon trigger to check if users ip adres is in out
range. The strange thing is : it now and then generates a trace file.
Could someone explain why.
Oracle8i Enterprise Edition Release 8.1.7.2.0
SunOS 5.8
I've edited the ip-range in the trigger for security reasons
Alert.log entry:
Errors in file /u01/app/oracle/admin/hlpdtest/udump/sid_ora_7112.trc:
ORA-00604: error occurred at recursive SQL level 1 ORA-20001: This service is for authorized personnel only ORA-06512: at line 32
The trigger:
CREATE OR REPLACE TRIGGER on_logon
AFTER LOGON
ON DATABASE
DECLARE
v_ip varchar2(15); v_usr varchar2(40); v_ses varchar2(40); v_host varchar2(40); v_date date;
, SYS_CONTEXT('USERENV','OS_USER'), v_host
, SYS_CONTEXT('USERENV','SESSION_USER')
, sysdate
INTO v_ip
, v_usr
, v_ses
IF v_ip NOT LIKE 'xxx.xxx.%'
THEN
INSERT INTO intruders VALUES (v_ip ,v_usr ,v_ses ,v_host ,v_date); COMMIT; RAISE_APPLICATION_ERROR(-20001, 'This service is for authorizedpersonnel only');
END IF;
END;
/
Received on Fri Nov 30 2001 - 08:23:28 CST