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
.

Relevant Pages