Re: Large XML string from Oracle?

In article <e15c115f.0108201337.313c78c7_at_posting.google.com>, hosie_owens_at_us.crawco.com says...
>
>I've read that there is a 4k limit on XML strings returned from PL/SQL
>because of the varchar2 limitations. I am using Microsoft ASP, VB/VC,
>Oracle stored procedures. What alternatives do I have?

the limit on varchar2 from plsql is 32k, not 4000 (a varchar2 stored in the database in a table is 4000bytes, plsql can return 32k however vai a stored procedure call)

Also, you can (should) use a CLOB -- then you have a 4gig limit.

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp