Would you please do me a favor?

Dear Tim Bunce,

I am in trouble to pass blob to stored function using
DBD::Oracle.

A stored function in oracle takes BLOB as input. I
can use JDBC . It works well.

In the document of DBD::Oracle, I was told that "For
the time being, only single-row LOB updates are
supported. Also passing LOBS to PL/SQL blocks doesn't
work." I wonder if passing blob to stored function
is
supported. I tried "select f(:blob) from dual" and
"Begin :result_blob := f(:input_blob) End", no lucky.

The error message I got is not helpful. It is
"ORA-29532: Java call terminated by uncaught Java
exception: java.sql.SQLException: Invalid empty lob
operation". it is a java stored function in oracle.
I think it has nothing to do with this stored
function. the question is how I can pass blob type
into the function using perl.

Please help me out.

Happy Holidays

Bin

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Re: Would you please do me a favor?

If you can give me example table,the function and the SQL you are trying in
JDBC I will have a look at it.
Can you also tell me what OS, and what version of DBD::Oracle and Oracle you
are using.

Seems to me that the latest version of DBD::Oracle should be able to do
this.

"bin zhou" wrote in message
news:469317.18444.qm@web52507.mail.yahoo.com...
> Dear Tim Bunce,
>
> I am in trouble to pass blob to stored function using
> DBD::Oracle.
>
> A stored function in oracle takes BLOB as input. I
> can use JDBC . It works well.
>
> In the document of DBD::Oracle, I was told that "For
> the time being, only single-row LOB updates are
> supported. Also passing LOBS to PL/SQL blocks doesn't
> work." I wonder if passing blob to stored function
> is
> supported. I tried "select f(:blob) from dual" and
> "Begin :result_blob := f(:input_blob) End", no lucky.
>
> The error message I got is not helpful. It is
> "ORA-29532: Java call terminated by uncaught Java
> exception: java.sql.SQLException: Invalid empty lob
> operation". it is a java stored function in oracle.
> I think it has nothing to do with this stored
> function. the question is how I can pass blob type
> into the function using perl.
>
> Please help me out.
>
> Happy Holidays
>
> Bin
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com