Unanswered: 64K limitation for the stored procedure (any solutions!!!?)
As facts show below:
1) Maximum size of an SQL statement is 64K
2) The maximum length of a DECLARE statement is 64 kilobytes.
3) Combined size of procedure code and its global variables are limited
to 64K per procedure
I have made a SP which takes a input parameter as the data type of "LIST". when I call this SP with the input parameter LIST containing over 3000 string (the string length is 10), I am not able to run this SP.
My guess is the problem of 64K limitation. Am I right?
Is there any possibilities and solutions to overcome the constrains? Appreciate if there is a way to do it!
The statement text in this PREPARE, DECLARE, or EXECUTE IMMEDIATE
statement is longer than the database server can handle. The actual
limit differs with different implementations, but it is always
generous, in most cases up to 32,000 characters. Review the program
logic to ensure that an error has not caused it to present a string
that is longer than intended (for example, by overlaying the null
string terminator byte in memory). If the text has the intended length,
revise the program to present fewer statements at a time.