utl_file

From: <cduvall_at_my-deja.com>
Date: Tue, 21 Sep 1999 16:48:45 GMT
Message-ID: <7s8ct8$jnb$1@nnrp1.deja.com>

I am trying to get utl_file working. I have Oracle 8.0.4 on NT. I set up the utl_file_dir initialization parameter. When I run a procedure such as:

declare

   v_file_id utl_file.file_type;
begin

   v_file_id := utl_file.fopen

                  ('e:\prodfiles\mfile\lifs',


                   'lif.txt',


                   'w');

end;
/

I keep getting an "utl_file.invalid_operation" exception. Is there a step I am missing to get this set up properly? I have checked all of the directory paths and the initialization parameter, but I can't figure out why this is not working.

Any advice would be greatly appreciated!!

Thanks alot,
Clayton DuVall

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Sep 21 1999 - 11:48:45 CDT