Re: Returning Large Strings From PLSQL

From: Daniel Morgan <damorgan_at_exesolutions.com>
Date: Mon, 10 Jun 2002 18:52:41 -0700
Message-ID: <3D0557E9.30251991@exesolutions.com>

Ranjith wrote:

> Some one kindly help me with this:
>
> How do I return strings that are bigger than 4000 characters
> from PLSQL to Java Client. Or, is there a way to capture
> dbms_output.print output and get it back in Java. I need to
> create some HTML formatted database reports (with tables) from PLSQL.
>
> Thank you,
>
> Ranjith

Two choices ...

1. VARCHAR2 variables are 32K. They are not 4K like the table field
2. CLOB

Either can be done though the VARCHAR2 easier if it will meet the requirement.

Daniel Morgan Received on Mon Jun 10 2002 - 20:52:41 CDT