If the data is being transferred over VARCHAR2 buffers, which it sounds like
it is, the limit is 32k-1 bytes of data. Please verify how the library and
interface are registered within Oracle.
Good Luck!
--
~~~~~~~~~~~~~~~~
Chris Weiss
www.hpdbe.com
High Performance Database Engineering
~~~~~~~~~~~~~~~~
"Grace" <gwallen_at_boeing.com> wrote in message
news:3CCDBCFD.199A482A_at_boeing.com...
> I have a Java JDBC program that selects a LONG RAW value from a table
> and converts it to a BLOB in another table.
>
> This works fine as a standalone JDBC program, but when I register it as
> a Java Stored Procedure in Oracle (8.1.6) and call it with a PL/SQL
> script, it only writes a maximum of 32767 bytes.
>
> Anyone know why ?
>
> Thanks in advance. Please post response or email to
> grace.wallen_at_boeing.com
>
> Grace Wallen
> Boeing SSG
> 253-657-5810
Received on Tue Apr 30 2002 - 10:33:13 CDT
