Re: Java Stored Function can't return strings longer than 4096 chars (ORA-24345)

In article <cwhe7.24201$mz2.1529534_at_e420r-atl1.usenetserver.com>, "Mike says...
>
>I'm running into a size limit that I don't think I should be running
>into (what else is new). I'm writing a Java stored function and I'm
>getting an ORA-24345 (A Truncation or null fetch error occurred). I can
>write a PL/SQL stored function that returns a 32k varchar2. See Sample
>code below.
>
>Does anyone know why this is? It really looks like a bug. Can someone
>try it on a different platform?
>

see
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:650337598357 for the details...

>Here's what I'm running on:
>
> Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production
> JServer Release 8.1.7.0.1 - Production
>
> RedHat Linux 6.2 with stock SMP kernel version 2.2.14
> on a 2 processor 800 Mhz Dell PowerEdge 1400 with 512 MB RAM.
>

--
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