GuardianOfTheFlame
Programmer
Hi all,
is there a limit to the number of parameters in a stored procedure?
I have an engine that generate a "CREATE PROCEDURE" script that receives in input a list of columns.
I cannot find a way to pass an array parameter in MySQL, so the XSLT must create a parameter for each column:
Potentially, the number of columns could be hundreds so I must know if there is a maximum number of parameters.
Thanks,
Matteo
---
The surest sign that intelligent life exists elsewhere in the universe is that none of it has tried to contact us - Calvin (and Hobbes) ;-)
is there a limit to the number of parameters in a stored procedure?
I have an engine that generate a "CREATE PROCEDURE" script that receives in input a list of columns.
I cannot find a way to pass an array parameter in MySQL, so the XSLT must create a parameter for each column:
Code:
CREATE PROCEDURE `sp_test`(IN Col1 VARCHAR(255), IN Col2 VARCHAR(255), IN Col3 VARCHAR(255), ...)
Thanks,
Matteo
---
The surest sign that intelligent life exists elsewhere in the universe is that none of it has tried to contact us - Calvin (and Hobbes) ;-)