UTL_FILE, list of files, remove file - how to?

UTL_FILE, list of files, remove file - how to?

Post by Eckart Schult » Sat, 17 Apr 1999 04:00:00



Hi,

Sorry, I'm a newbie in PL/SQL.
How do I get a list of files in a (server-sided) directory? How do I remove
a file after reading it?

Thanks for any help
Eckart

 
 
 

UTL_FILE, list of files, remove file - how to?

Post by Marc Parkinso » Mon, 19 Apr 1999 04:00:00


Sorrr, you cant do that
Utl_File provides the following subprograms
FOPEN                Open a file for input or ouput. Create an output file if
it does not exist.

 IS_OPEN            Determine if a file handle refers to an open file.

 FCLOSE              Close a file.

 FCLOSE_ALL    Close all open file handles.

 GET_LINE           Read a line of text from an open file.

 PUT                      Write a line to a file. Do not append a line
terminator.

 PUT_LINE            Write a line to a file. Append an OS-specific line
terminator.

 PUTF                 A PUT procedure with formatting.

 NEW_LINE            Write one or more OS-specific line terminators to a file.

 FFLUSH               Physically write all pending output to a file.

Sorce
                                Oracle7.3 Server Application Developer's Guide

Marc Parkinson


> Hi,

> Sorry, I'm a newbie in PL/SQL.
> How do I get a list of files in a (server-sided) directory? How do I remove
> a file after reading it?

> Thanks for any help
> Eckart


 
 
 

UTL_FILE, list of files, remove file - how to?

Post by Marc Parkinso » Mon, 19 Apr 1999 04:00:00


Sorrr, you cant do that
Utl_File provides the following subprograms
FOPEN                Open a file for input or ouput. Create an output file if
it does not exist.

 IS_OPEN            Determine if a file handle refers to an open file.

 FCLOSE              Close a file.

 FCLOSE_ALL    Close all open file handles.

 GET_LINE           Read a line of text from an open file.

 PUT                      Write a line to a file. Do not append a line
terminator.

 PUT_LINE            Write a line to a file. Append an OS-specific line
terminator.

 PUTF                 A PUT procedure with formatting.

 NEW_LINE            Write one or more OS-specific line terminators to a file.

 FFLUSH               Physically write all pending output to a file.

Sorce
                                Oracle7.3 Server Application Developer's Guide

Marc Parkinson


> Hi,

> Sorry, I'm a newbie in PL/SQL.
> How do I get a list of files in a (server-sided) directory? How do I remove
> a file after reading it?

> Thanks for any help
> Eckart

 
 
 

UTL_FILE, list of files, remove file - how to?

Post by Peter Weis » Wed, 21 Apr 1999 04:00:00


Hy,

if you are working on Oracle 8.x you can use
external procedures to do this things for you.

Peter


> Hi,

> Sorry, I'm a newbie in PL/SQL.
> How do I get a list of files in a (server-sided) directory? How do I remove
> a file after reading it?

> Thanks for any help
> Eckart