This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
Hi, Environment :- DB2 (7.2.10) Websphere (5.2) I have a string of size 145290 bytes and am trying to Insert it into the DB using a stored procedure. The stored procedure accepts a clob. How can i create a clob to be passed on the Stored Procedure. The parameter is registerd with the DB as INOUT. So Once i execute the stored procedure, I should be able to get back the updated parameter. I tried registering the parameter as "LONGVARBINARY" and it works fine for sending the INPUT to the stored procedure. But i cant retreive the parameter after SP execution. I am trying to use the following code to register the parameter as CLOB callStatement.registerOutParameter(1,Types.CLOB); Also as this parameter is an IN/OUT type. I want to know how to read the value coming back from the callStatement execution. Please help me out. Thanks Praveen [ April 29, 2004: Message edited by: Praveen Dharmavaram ] [ April 29, 2004: Message edited by: Praveen Dharmavaram ]