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" <bin_zhouemail@xxxxxxxxx> wrote in message
news:469317.18444.qm@xxxxxxxxxxxxxxxxxxxxxxxxxx
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


.

Relevant Pages