PL/SQL - Trigger gets UTL_FILE.INVALID_PATH
From: TL <lamkin_at_tiac.net>
Date: 1998/03/02
Message-ID: <01bd4630$890c4860$c74b3dd1_at_l58cb9>#1/1
Date: 1998/03/02
Message-ID: <01bd4630$890c4860$c74b3dd1_at_l58cb9>#1/1
[Quoted] I am trying to use the UTL_FILE.FOPEN, and I get the invalid path error, even though the D:\ORANT\BWVAUDIT directory is in the Oracle ini file. code follows...Any ideas?
CREATE OR REPLACE TRIGGER tbw009_log_trigger
AFTER DELETE OR UPDATE ON tbw009_cust
FOR EACH ROW
DECLARE
audit_file UTL_FILE.FILE_TYPE;
file_dir varchar2(255) := 'D:\ORANT\BWVAUDIT\';
file_name varchar2(255) := 'TBW009.AUD';
file_write varchar2(1) := 'w';
BEGIN
DBMS_OUTPUT.PUT_LINE ('Entering the logic.');
audit_file := UTL_FILE.FOPEN(file_dir, file_name, file_write);
IF UTL_FILE.IS_OPEN(audit_file) THEN
UTL_FILE.PUT_LINE(audit_file,
'this line is being added');
END IF;
EXCEPTION
WHEN UTL_FILE.INVALID_PATH THEN
DBMS_OUTPUT.PUT_LINE ('Invalid Path.');
WHEN UTL_FILE.INVALID_MODE THEN
DBMS_OUTPUT.PUT_LINE ('Invalid Mode.');
WHEN UTL_FILE.INVALID_OPERATION THEN
DBMS_OUTPUT.PUT_LINE ('Invalid Operation.');
END; Received on Mon Mar 02 1998 - 00:00:00 CET
