Need help on Stored Procedure Call with CLOB as IN Parameters

[Chintan B Shah]

Hi Folks,

I need to call a stored procedure where 2 of its IN parameters are of CLOB data type.

Stored procedure looks something like this

abc.EVENT(
        Emails                  			IN CLOB,
        Subject                 			IN VARCHAR2,
        Body                			        IN CLOB,
        Results                 			OUT VARCHAR2
);

I have to query another application(through web-service) to get Emails, subject , body. I get all of those as String.

So I wrote the code that uses a callable statement and does following

   //tried both(one at a time) and none of them works
   cs.setClob(3, new StringReader(body)); //cs is an object of class CallableStatement
   cs.setCharacterStream(3, new StringReader(body));

No errors, exceptions are thrown. Code just stops while executing those lines and exits.

ENV: JDK1.6, OJDBC14.JAR in class path.

Any help on troubleshooting this is much appreciated.

Best Regards,
Chintan.

[Fatih Keles]

As far as I remember setString will do the trick for reasonable length Strings in newer drivers. But you should check the documentation for details.

By the way you must also use appropriate driver for your database version.

Regards,
Fatih.

[Chintan B Shah]

Hi Fatih,

Yes, you are right. I was googling around more after posting this topic and found this link

String To Clob in Java

which also says the same thing.

setString did work for my scenario.

Thanks much.

Best Regards,
Chintan.