Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to read over 2000 characters in a data file?
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
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 CST