OraFAQ Forum: Forms » TEXT_IO can't read very long lines

Home » Developer & Programmer » Forms » TEXT_IO can't read very long lines

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

TEXT_IO can't read very long lines [message #80157]

Fri, 16 August 2002 01:50

peter happe
Messages: 1
Registered: August 2002

Junior Member

hi all!

i need to import files to a client-side forms application. the problem is that one file consists of one very large line.
the GET_LINE function is limited to max length of varchar2.

is there a possibility to read text files character by character?

how can i split this line in smaller parts?

thanx in advance

regards

peter

Report message to a moderator

Re: TEXT_IO can't read very long lines [message #80530 is a reply to message #80157]

Wed, 09 October 2002 01:40

Shiju
Messages: 12
Registered: October 2002

Junior Member

Yeah

It has a limit of 2000 chars.
Split the lines using substr into different variables, limited to 2000 chars in each var and
process the variables.

I did it

Shiju

Report message to a moderator

Previous Topic:	CREATING USER IN ORACLE DATABASE
Next Topic:	Re: Oracle Forms 6i 'Exit the application'.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 06:53:51 CDT 2024