Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » using TEXT_IO  () 1 Vote
icon5.gif  using TEXT_IO [message #165480] Thu, 30 March 2006 09:00 Go to next message
Messages: 1
Registered: March 2006
Location: Argentina
Junior Member
Hi, I need to read a txt and insert into a table the data. To do that I want to create a procedure using TEXT_IO.FOPEN and TEXT_IO.GET_LINE, but when I save the procedure, show me the next error:

ERROR in line 6: PLS-00201: the identifier 'TEXT_IO.FILE_TYPE' must to be declare.

How I can solve this?

Re: using TEXT_IO [message #165945 is a reply to message #165480] Mon, 03 April 2006 09:33 Go to previous message
Venkanna Mittakanti
Messages: 3
Registered: January 2004
Junior Member
are you using HTML DB to execute this procedure? TEXT_IO is a client-side built-in package. There is no text_io package on the server side.I don't think this package works from HTML DB. HTML DB is a web thin client which part of the db. Try using UTL_FILE package instead of text_io.

Previous Topic: what is html-db and for wat purpose it is used?
Next Topic: Is there a shared calendar component in HTMLDB?
Goto Forum:

Current Time: Fri Feb 23 02:13:30 CST 2024