I have a simple stored procedure:

create procedure test(my_clob clob)
returning clob;
set debug file to '/tmp/test.log';
trace on;
return my_clob;
end procedure;

I'm calling this way via jdbc:

StringReader stream1 = new StringReader(scripts);
CallableStatement cs = conn.prepareCall("{ ? = call markTest(?) }");
//cs.setString(1, scripts);
cs.setCharacterStream(1, stream1, scripts.length());
cs.execute();
conn.close();

Setting with a character stream I get this:

java.sql.SQLException: Type not supported

If I try and pass a string I get this:

java.sql.SQLException: blob_input: cannot convert LO from argument string


Here is my configuration:

Informix Dynamic Server 9.30.HC5X4
IBM Informix JDBC Driver Version 2.21.JC5
HP-UX B.11.11 U 9000/800 145444606