RE: UTL_FILE

[Mercadante, Thomas F]

Title: UTL_FILE

Eric

 

Utl_file only write to the database server.  You can use Dbms_Output and spool the results to the local machine.  Or 'select' the data to be spooled out.

 

Hope this helps!

 

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
From: Harrington, Eric [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 11, 2003 2:30 PM
To: Multiple recipients of list ORACLE-L
Subject: UTL_FILE

Any help would be appreciated...

Is it possible to write a file to the local OS if the database is remote? Should I be using UTL_FILE or another package?

I'm attempting to write to a file on my local OS (Windows NT 4.0). The database version is 9i r2 and resides on a HP-UX box. I've created a directory object as follows:

CREATE OR REPLACE DIRECTORY utl_file_dir AS 'c:\';

The output from the SQL statement: select * from all_directories; follows:

OWNER  DIRECTORY_NAME DIRECTORY_PATH

------------- ------------------------------  ----------------------------

SYS       UTL_FILE_DIR           c:\

File handle code from my procedure follows:

  l_FileHandle := UTL_FILE.FOPEN('UTL_FILE_DIR','role.txt','r');

When executing the associated procedure I get the following error:

ORA-29280: invalid directory path

Thanks, Eric Harrington