Re: How to read over 2000 characters in a data file?
From: Joris de Groen <jgroen_at_bart.nl>
Date: 1997/11/17
Message-ID: <64pjn7$hk4$1_at_news.bart.net>#1/1
Joris de Groen, DBA Consultant
Date: 1997/11/17
Message-ID: <64pjn7$hk4$1_at_news.bart.net>#1/1
Dear Jimmy.
Only the varchar2 in the database has a limit of 2000.
The limit in Forms and PL/SQL in 32K.
Joris de groen
Joris de Groen, DBA Consultant
Transfer DBA Solutions bv tel. 0345 637769 Meent32 C fax. 0345 616300 4141 AC Leerdam jreijm_at_transfer-solutions.com Nederland http://www.transfer-solutions.com --------------------------------------------------------------------
Jimmy heeft geschreven in bericht <34557DB9.12D3_at_comp.polyu.edu.hk>...
>I want to use text_io packages to read data file content in Form 4.5. I
>declare a variable to hold each line input as varchar2(2000). (since the
>max. characters hold in varchar2 is 2000)
>If a row in the data file is over 2000 characters, how can I read such
>line with text_io package in Form 4.5?
>
>Thanks,
>Jimmy
Received on Mon Nov 17 1997 - 00:00:00 CET