RE: max row length in dbms_sql.varchar2_table
- From: "John Dunn" <jdunn@xxxxxxxxx>
- To: "'Nigel Thomas'" <nigel@xxxxxxxxxxxxxx>
- Date: Wed, 13 Sep 2006 12:47:01 +0100
How can I create an array of varchar2(3000)?
John
-----Original Message-----
From: Nigel Thomas [mailto:nigel@xxxxxxxxxxxxxx]
Sent: 13 September 2006 12:29
To: jdunn@xxxxxxxxx
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@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
