Is there a datatype to pass as an out parameter to a stored procedure in Sybase that can hold indefinite amount of data? I learnt that we cannot use text as a datatype. Please help me out
Since you need more storage, you may have to logically split your input into 1 or more varchar(n).
The max size for a single varchar is the server page size (2k, 4k, 8k, or 16k depending on your environment).