Home » SQL & PL/SQL » SQL & PL/SQL » Text File
Text File [message #36115] Tue, 06 November 2001 07:47 Go to next message
adelia
Messages: 45
Registered: April 2001
Member
How can I access and read a Text File ?
Someone has a script ?

Thanks in advance...

----------------------------------------------------------------------
Re: Text File [message #36116 is a reply to message #36115] Tue, 06 November 2001 08:27 Go to previous messageGo to next message
Somu
Messages: 24
Registered: February 2000
Junior Member
Hi,

I am not clear about your requirement, could you tell me which one of the following you wanted to use.

1. PRO*C
2. PL/SQL
3. SQL

----------------------------------------------------------------------
Re: Text File [message #36119 is a reply to message #36115] Tue, 06 November 2001 09:57 Go to previous messageGo to next message
adelia
Messages: 45
Registered: April 2001
Member
I executed the example on the SQL PLUS, but there is this error :

ORA-06550: line 2, column 11:
PLS-00201: identifier 'TEXT_IO.FILE_TYPE' must be declared
ORA-06550: line 2, column 11:

Do you Know why ?

Thanks

----------------------------------------------------------------------
Re: Text File [message #36123 is a reply to message #36115] Tue, 06 November 2001 11:23 Go to previous message
Pratima
Messages: 2
Registered: November 2001
Junior Member
Use UTL_FILE package instead of TEXT_IO package.
For more info on UTL_FILE package you can refer to Oracle Documentation.

The UTL_FILE package is similar to the client-side TEXT_IO package currently provided by Oracle Procedure Builder.

----------------------------------------------------------------------
Previous Topic: Date Format
Next Topic: Re: About insert data into a table which created in pl/sql
Goto Forum:
  


Current Time: Fri May 27 23:27:15 CDT 2022