wood burning stoves 2.0*
The moose likes JDBC and the fly likes CLOBS Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "CLOBS" Watch "CLOBS" New topic


Praveen Dharmavaram
Ranch Hand

Joined: Nov 05, 2002
Posts: 59
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
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.
[ April 29, 2004: Message edited by: Praveen Dharmavaram ]
[ April 29, 2004: Message edited by: Praveen Dharmavaram ]
jQuery in Action, 2nd edition
subject: CLOBS
Similar Threads
How to call stored procedure from Entity Manager if there is out parameter in stored procedure.
Inserting CLOB(URGENT)
Mapping java collections as In parameters to Varrays
calling stored procedure