Re: UTL_FILE problems

The value for UTL_FILE_DIR in the control file is case sensitive.

Ensure that the path you give the fopen command is the same case as the one in the control file.

Mike

Scott Buyer <scottb_at_verio.net> wrote in message news:jia25.51689$5k2.106919_at_dfw-read.news.verio.net...
> I cannot get the fopen function of this package to run. I added the
> directory I am accessing to the control file, I create the variable of
 type
> UTL_FILE.FILE_TYPE;
>
> Here is my code in the proc
>
> CREATE OR REPLACE PROCEDURE XACCT.SUMMARIZE_USAGE_DETAIL_2_DED (V_STR_DATE
> CHAR)
> IS
> -- UTL file declaration
> d_exception_file1 UTL_FILE.FILE_TYPE;
> d_exception_file2 UTL_FILE.FILE_TYPE;
> d_directory1 varchar2(50) := '/apps/xacct/Reports/';
> d_directory2 varchar2(50) := '/apps/xacct/Reports/';
> v_test varchar2(50) := 'test1.txt';
> v_test2 varchar2(50) := 'test2.txt';
> BEGIN
> --CREATE DATE VARIABLE WHICH HAS TIME A SET TO 00:00:00
> begin
> d_exception_file1 :=
> UTL_FILE.FOPEN('/apps/xacct/Reports/','test1.txt','A');
> exception
> when others then
> dbms_output.put_line('1 errored out with ' || SQLERRM);
> end;
> begin
> d_exception_file2 := UTL_FILE.FOPEN(d_directory2,v_test2,'A');
>
> The open fails.
>
> Any thoughts out there.
>
>
>
Received on Fri Jun 16 2000 - 00:00:00 CDT