Hey fred like I mentioned I'm also a win32 user and had similar
results(things just aren't working the installer version was even worse).
But the problem with the example below is the parameter in the select
statement(param1) which should be the same as the parameter
in the procedure definition(param11)
(The documentation has a mistake/typo.)
you could do
CREATE PROCEDURE simpleproc (OUT param11 INT)
declare param1 int;
SELECT COUNT(*) INTO param1 FROM t;
param11 = param1;(may need to use "set param11 = param1;" thankfully in
oracle you don't have to do this)
mysql> CREATE PROCEDURE simpleproc (OUT param11 INT)
> -> SELECT COUNT(*) INTO param11 FROM t;
> -> |
Just to add I couldn't get compound statements to work
with an example like
create procedure foo(in name varchar(10))
begin
sql stmt 1
sql stmt 2
end
basically up to this point all that worked for me was/is
create procedure foo(parameter)
sql stmt (either select or insert)
and thats it !
Scary part is I have worked on oracle and sql server for the last 5 years
and the mysql procedures are more like sql server than oracle.
it lacks structure, look at sql server stored procs and you'll know what I
mean just hunks of sql everywhere it's a mess.
----- Original Message -----
From: "Fredrick Bartlett" <palmtreefrb@stripped>
To: <win32@stripped>
Sent: Friday, January 02, 2004 11:08 PM
Subject: Re: MySQL 5.0
> This example (also from mysql doc's) does not work as well...
> mysql> delimiter |
> mysql> CREATE PROCEDURE simpleproc (OUT param11 INT)
> -> SELECT COUNT(*) INTO param1 FROM t;
> -> |
> ERROR 1311 (42000): Undeclared variable: param1
> mysql>
>
>
> ----- Original Message -----
> From: "robert_rowe" <robert_rowe@stripped>
> To: <win32@stripped>
> Sent: Friday, January 02, 2004 2:12 PM
> Subject: Re: MySQL 5.0
>
>
> >
> > Follow this link to the appropriate chapter in the manual. Nothing
should
> be different just because it is on Win32.
> >
> > http://www.mysql.com/doc/en/Stored_Procedures.html
> >
> > --
> > MySQL Windows Mailing List
> > For list archives: http://lists.mysql.com/win32
> > To unsubscribe:
> http://lists.mysql.com/win32?unsub=1
> >
>
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
http://lists.mysql.com/win32?unsub=1
>
