Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Java Stored Function can't return strings longer than 4096 chars (ORA-24345)
A little more data. On 8.1.5 on WindowsNT, the same test does not give the ORA-24345, but only 4097 of the 32000 bytes gets returned. It automatically truncated the 32000 byte string to 4097 bytes without returning an error.
This still seems like a bug since I can't find any documented limit on the return string length other than the 32k limit.