File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Callable statement return xml result

 
Nagu Spartan
Ranch Hand
Posts: 40
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi

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

 
Prabhakar Reddy Bokka
Ranch Hand
Posts: 196
Java Oracle Spring
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 40
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 196
Java Oracle Spring
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thats where CLOB comes into picture. CLOB do not have any limit.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic