I vaguely remember something about not having a trailing slash in the
directory name. Try removing it.
Mike Resnick
LOGICON Corp.
Scott Buyer wrote in message
<642A954DD517D411B20C00508BCF23B001254806_at_mail.sauder.com>...
>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 Tue Jun 27 2000 - 00:00:00 CDT