Stored procedures from MySql 5.0

[amorales]

Hello.

I´m programming in PowerBuilder 8.0.
I have installed: MySql 5.0.1 Beta and ODBC 3.51.

I have 2 questions:

MySql:

1- i Created a Store Procedure, that make a SELECT * FROM TABLEx; at the end.
if i call the SP since command line of mysql, it runs succefully; but if i call the SP since another SQL editor (MySql-Front in this case), it return the error-message ''Result Select in a Stored Procedure Must have INTO'. The question is: How can i make a SELECT * FROM TABLEx since a SP?.

I know is necessary use: SELECT field1,.., fieldn INTO var1,..,varn FROM TABLEx, to get one by one the records. When i made that and called the procedure, it return the error: 'Result consisted in More than one Row'

2- I have tried to use a CURSOR but the DBMS return the error: ERROR 1337 (42000): Cursor declaration after handler declaration




PowerBuilder:
3- When i am painting a new DataWindow since PowerBuilder, it does not recognize the Stored Procedures from MySql. Someone knows why?


TIA.
Anselmo.