OS file

Hi Every One
I'm a freshman in PL/SQL. I met a problem when attempt to write a client side os file.
Following is the program. It's a SQL Plus script.

set serveroutput on
declare

f_handle utl_file.file_type;
path varchar2(40) :='d:\tapeload';
fn varchar2(40) :='t6.dat';
md varchar2(40) :='w';

begin

  f_handle:=utl_file.fopen(path,fn,md);   utl_file.fclose(f_handle);
  dbms_output.put_line(pidm||'qwewrewer' );

exception
when utl_file.invalid_path
  then dbms_output.put_line('invalid_path'); when others
  then dbms_output.put_line('other');

end;
/

I always got following error.

invalid_path
declare
*
ERROR at line 1:
ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at line 22

Input truncated to 1 characters

I'm using ORACLE7 and Sql Plus 3.3w. And the DATABASE is on a remote unix server, my local OS is NT4.0.
The path(d:\tapeload) and file(t6.dat) exist on local PC.

Does anyone know where the problem is ? Thank you in advance for help? Received on Sat Jun 06 1998 - 19:02:36 CDT