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

  • From: "John Dunn" <jdunn@xxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 13 Sep 2006 13:05:06 +0100

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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 09-2006