This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
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’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link:
subject: CLOBS
It's not a secret anymore!