Archives of the TeradataForum

Message Posted: Mon, 23 Nov 2015 @ 21:05:11 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi Forum -

Teradata version - 15.00

I am trying to create a stored procedure which has input parameter size exceeding 64 KB and it is giving the error 'CALL Failed.9804: Response Row size or constant Row size overflow'. This is for an application and the input parameters contains huge XML data. We are facing challenges with processing XML data and hence declared the parameters as VARCHAR(64000), however I believe the input parameters size cannot exceed 64KB and the SP throws the error 'CALL Failed.9804: Response Row size or constant Row size overflow'.

Could anyone provide me any workarounds for this?

Greatly appreciate any inputs that I can try.

Thanks

Roopalini

	<Prev	Next>		<<First	<Prev	Next>	Last>>