maximum characters/bytes of text (varchar/clob) that can be returned by a Teradata Stored Procedure

Database
Teradata Employee

maximum characters/bytes of text (varchar/clob) that can be returned by a Teradata Stored Procedure

Hi folks,

We are looking at executing some dynamic SQL from some Stored Procedures.

I wanted to know what is the maximum number of characters or bytes that can be returned from a Stored Procedure, based on an "OUT" param having VARCHAR or CLOB Data Type. Has anyone already explored this...

From the Teradata Documentation, we have seen the below mentioned statement...

"The total data size of all input and all output parameters in a CREATE/REPLACE PROCEDURE cannot exceed 64000 bytes."

Thanks in advance.

-Bilal