Returning Huge XML data from procedure

AB7771

Hi, I have procedure which returns huge xml data in ref cursor from Oracle procedure, When the procedure is executed in Toad, it works fine, But when my method calls the procedure it returns an empty row in the datatable. any help would be appreciated.

Thanks & Regards, Pramod "Everyone is a genius at least once a year"

Bernhard Hiller

What does your method return in case of errors (e.g. timeout) - an empty row? And what's the expected size of that xml string - GigaBytes? Then you ought to consider a different design.

AB7771

it doesn't throws any errors, now I have changed and tried using a DataReader and that works. The XML contains more than 2000 lines and file size is just 83KB. Somehow the DataReader can perform the operation, but the DataAdapter is not filling the datatable. Is there some kind of size limit?

Thanks & Regards, Pramod "Everyone is a genius at least once a year"

jschell

AB7771 wrote:

Is there some kind of size limit?

There are always size limits. You might try slightly below 64k if you are interested. If that doesn't work then try 32k, etc.