Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Howto return data > 4k from a stored procedure ?!

Howto return data > 4k from a stored procedure ?!

From: Andreas Jung <ajung_at_sz-sb.de>
Date: Mon, 17 Jul 2000 09:15:23 +0200
Message-Id: <10561.112147@fatcity.com> 





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
Received on Mon Jul 17 2000 - 02:15:23 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US