This week's giveaway is in the Programmer Certification (OCPJP) forum.
We're giving away four copies of Java Mock Exams (software) and have David Mayer on-line!
See this thread for details.
Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

CLOBS

 
Praveen Dharmavaram
Ranch Hand
Posts: 59
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
Happiness is not a goal ... it's a by-product of a life well lived - Eleanor Roosevelt. Tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!