Re: UTL_FILE problems

make sure you have the following entry in your init.ora file:

utl_file_dir = *
In article
<642A954DD517D411B20C00508BCF23B001254806_at_mail.sau der.com>,
  "Scott Buyer" <scottb_at_verio.net> wrote:
> 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.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Jul 14 2000 - 00:00:00 CDT