RE: max row length in dbms_sql.varchar2_table

How can I create an array of varchar2(3000)?

John

-----Original Message-----
From: Nigel Thomas [mailto:nigel_at_preferisco.com] Sent: 13 September 2006 12:29
To: jdunn_at_sefas.com
Subject: Re: max row length in dbms_sql.varchar2_table

type Varchar2_Table is table of varchar2(2000) index by binary_integer;

(just DESCRIBE DBMS_SQL)....

Cheers

Nigel

• Original Message ---- From: John Dunn <jdunn_at_sefas.com> To: oracle-l_at_freelists.org Sent: Wednesday, September 13, 2006 11:17:51 AM Subject: max row length in dbms_sql.varchar2_table

Is there a maximum length to the data that I can place in an occurrence of a dbms_sql.varchar2_table array?

Oracle version is 8.1.7

John Dunn
Product Consultant
Direct Dial +44 (0) 117 373 6122
Sefas Innovation Ltd, CityPoint, Temple Gate, Bristol BS1 6PL, UK. Tel: +44(0) 117 373 6114
Fax: +44 (0) 117 373 6115

www.sefas.com

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