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
