I don't know whether I understand your requirement
because I am clueless regd Java stuff (right now). We
had a similar requirement where we had to return a
huge amount of data from a stored procedure. The
workaround was to use a temporary table. The stored
procedure would populate the table and send a
'Success' as the return string. The calling program
would then access the table directly to get the
results. Does this help at all ?>
- Andreas Jung <ajung_at_sz-sb.de> wrote:
> We are using Java stored procedures inside an Oracle
> 8i database.
> Some of the procedure need to return strings between
> 4k and 100k
> large (either as return parameter or as OUT
> parameter). But the
> Oracle datatype to Java datatype mapping does not
> allow
> to pass strings > 4k because VARCHAR2 is limited to
> 4000 bytes.
>
> Is there a way to get rid of this limitation ?
>
> Andreas
> --
> Author: Andreas Jung
> INET: ajung_at_sz-sb.de
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Oracle DBA,
Minneapolis, MN
USA
Do You Yahoo!?
Get Yahoo! Mail – Free email you can access from anywhere!
Received on Thu Jul 20 2000 - 10:29:59 CDT
