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.