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" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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
