Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Java Stored Proc Question
This might be due to differences in server-side JDBC driver. You didn't
post any code to dig, neither you gave the version of the Oracle client
(and JDBC driver) where it works, so it's hard to tell what the problem
actually is. Exact version of the database (5 digits) can also help. And
you don't need Java to convert LONG RAW to BLOB. Look up TO_LOB
function in SQL Reference.
-- Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications. All opinions are mine and do not necessarily go in line with those of my employer. "Grace" <gwallen_at_boeing.com> wrote in message news:3CCDBCFD.199A482A_at_boeing.com...Received on Tue Apr 30 2002 - 02:40:46 CDT
> 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