Text File [message #36115] |
Tue, 06 November 2001 07:47 |
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 |
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 |
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 |
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.
----------------------------------------------------------------------
|
|
|