Who to use package utl_file ?

Hay ye'all

I have the following problem/question:
- How can I create a (e.g. text) file in pl/sql (stored procedure) ? (e.g. c:\temp\temp.txt)???

It is easy to create this in a library with the text_io package, but this package is of course not usable in a stored procedure...so, use the utl_file. But this package gives errors when I want to use it:

SQL> declare
  2 ft utl_file.file_type;
  3 begin
  4 ft := utl_file.fopen('C:\temp\','temp.txt','w');   5 end;
  6 /
declare
*
ERROR at line 1:

ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "SYS.UTL_FILE", line 82
ORA-06512: at "SYS.UTL_FILE", line 120
ORA-06512: at line 4

Can anyone help me with this? Am I using the utl_file package improperly??

Erwin Received on Wed Sep 09 1998 - 00:00:00 CDT