Re: PL/SQL - Trigger gets UTL_FILE.INVALID_PATH

Make sure that you have the utl_file_dir set in yout init.ora file. If not you will always get the error.

This will give the caller permission to wite to any directory utl_file_dir = *

This will allow the caller to only write to the directory utl_file_dir = D:\ORANT\BWVAUDIT

TL <lamkin_at_tiac.net> wrote in article <01bd4630$890c4860$c74b3dd1_at_l58cb9>...
> 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 Tue Mar 03 1998 - 00:00:00 CET