Can you write your own varchar2 array instead of using the dbms_sql? I forgot 8i syntax, but you should look in the doc if you have something like this: subtype my_varchar2_type is varchar2(32767) (available in 9i - max 32K) type my_type_v2 is table of my_varchar2_type index by pls_integer;
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?