Callable statement return xml result

[Nagu Spartan]

Hi

In java, CallableStatement how to get XML formated output from Stored procedure (SQL Server 2005).

[Prabhakar Reddy Bokka]

Your stored proc will return an object. that is a String or CLOB or BLOB.

From Java, you will take that String(in your case XML as a String), and process it.
It can be CLOB or BLOB also when your XML is too large in size.

[Nagu Spartan]

It takes only 4000 character... if my output from stored procedure is more than 4000 character means, it take 4000 character and remaining is truncated.

Prabhakar Reddy Bokka wrote:Your stored proc will return an object. that is a String or CLOB or BLOB.

From Java, you will take that String(in your case XML as a String), and process it.
It can be CLOB or BLOB also when your XML is too large in size.

[Prabhakar Reddy Bokka]

thats where CLOB comes into picture. CLOB do not have any limit.