OraFAQ Forum: Application Express, ORDS & MOD_PLSQL » using TEXT

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » using TEXT_IO (

) 1 Vote

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

using TEXT_IO [message #165480]

Thu, 30 March 2006 09:00

chepi
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?

Attachment: PROCEDIMIENTO.txt
(Size: 1.99KB, Downloaded 1560 times)

Report message to a moderator

Re: using TEXT_IO [message #165945 is a reply to message #165480]

Mon, 03 April 2006 09:33

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.

Thanks,Venkanna

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 18:26:28 CDT 2024