On 7/25/06, Visolve DB Team <mysql_support@stripped> wrote:
> Hello Jon.
Hi there Team :)
And thanks for the quick reply
Could you tell me the version of MySql ?. You can find the version by
> excuting the command
> SELECT version()
> If the version is below 5, the stored procedure feature would not work .
The version shown is 5.0.21-standard (from the rpm
I have no problem with other sp, like:
CREATE PROCEDURE sp_test3 (IN value int)
select count(*) from some_table where foo > value;
It's just defining table and limit I've had problems with (there is also one
mentioning this in the manual about creating sp
So could it be that it's not possible?
> Visolve DB Team.
> ----- Original Message -----
> From: "Jon" <mysql@stripped>
> To: <mysql@stripped>
> Sent: Tuesday, July 25, 2006 2:40 PM
> Subject: Stored procedures
> > Hi list
> > I'm trying to make stored procedures use parameters for limit and
> > I
> > guess this is either me using the wrong datatype or it's not possible.
> > I'm
> > having the same issue with seting the table for the query:
> > CREATE PROCEDURE sp_test1 (IN some_limit int)
> > select * from some_table limit some_limit;
> > and
> > CREATE PROCEDURE sp_test2 (IN some_table table)
> > select * from some_table;
> > Both fail with "ERROR 1064 (42000)".
> > Can someone please shed some light on this for me? Is this a problem
> > procedures not being able to do this or is it wrong datatypes or
> > completely different?
> > Thanks in advance
> > Jon