File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes CLOBS Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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 ]
I agree. Here's the link:
subject: CLOBS
It's not a secret anymore!