Paremeter String length in Stored Procedure

[jliang]

Hi,

I have a store procedure to pass a string as parameter, when the string length is less than 100, the SP runs fine, when I pass the string longer than 230, I got error code: 3706. When I catch the SQL and run on queryman, it works fine.

Can anyone tell me is there any limit size for a parameter string? How can I fix or avoid this problem?

Many thanks in advance

Jing

 

[tdatgod]

When you catch the SQL?

What program is generating the SQL with the really long line? Is that program using CLI instead of ODBC to connect to Teradata?

---