Using a text file in PL/SQL

[meridian99]

I'm looking for some example code in Oracle Pl/sql v2.3 language using oracle 7.34 that manipulates a text file to;

- create an empty text file and name it with todays date (20020102.dat)
- code to open it and append data as records (from variables)
- code to close the text file

I'm just starting our with PL/Sql programming....
thanks !

 

[lewisp]

You need to use the UTL_FILE package.

Go to

http://belinda.lon.bt.com/oracle/ora_815_doc/DOC/index.htm

and do a search for UTL_FILE whcih will explain all the commands you can use to create text files.