aspose file tools*
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 EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "CLOBS" Watch "CLOBS" New topic
Author

CLOBS

Praveen Dharmavaram
Ranch Hand

Joined: Nov 05, 2002
Posts: 59
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 ]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: CLOBS
 
Similar Threads
Mapping java collections as In parameters to Varrays
Inserting CLOB(URGENT)
How to call stored procedure from Entity Manager if there is out parameter in stored procedure.
java.lang.ClassCastException
calling stored procedure