Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> ***Urgent help needed with PL/SQL array ****

***Urgent help needed with PL/SQL array ****

From: John Dunn <jdunn_at_sefas.com>
Date: Wed, 13 Sep 2006 13:05:06 +0100
Message-ID: <004c01c6d72c$daa531f0$3e04050a@johnman>


I am using a dbms_sql.varchar2_table to store records from a utl_file read.

The problem I have hit is that varchar2_table in dbms_sql is defined as varchar2(2000).

I ugently need to be able to define an array that will hold more than 2000 characters.

Platform is Oracle 8.1.7

Can anyone help?

John


--
http://www.freelists.org/webpage/oracle-l


Received on Wed Sep 13 2006 - 07:05:06 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US