cancel
Showing results for 
Search instead for 
Did you mean: 

Receiver JDBC : Stored procedure with CLOB manipulation

Former Member
0 Kudos

If anybody has worked on similar scenario, can please share the experience / problems encountered ?

My requirement is to call a stored procedure in Oracle database on the receiver JDBC side. The pecularity is that the stored procedure has an IN OUT parameter of CLOB type, and JDBC has a bug which requires Application server specific APIs to be used here, if you happen to make such a call from within a J2EE application. I want to know if this is handled in XI JDBC adapter and if yes, any links with detailed information about that....those who wish to know more...the problem is about the method

oracle.sql.CLOB.createTemporary();

where oracle.sql.CLOB is the class that implements java.sql.Clob.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

HI,

Please see the below links

Regards

Chilla

<i>reward points if it is helpful..</i>