Why the error?

[victor nunez]

Hi everyone

I'm trying to use a stored proc in mysql and works fine while in mysql client, but when i try to call it from asp or MySQl Control Center y get these errors:

ASP - Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[MySQL][ODBC 3.51 Driver][mysqld-5.0.0-alpha-nt]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'rtrv_st_marks ('8A')' at line 1

C.C.- [user] ERROR 1296: SELECT in a stored procedure must have INTO

I'm migrating from MSSQL and usually SP's work even without 'INTO' clause or have to put results in variables or temp tables.

Am I supposed to use cursors or how can i troubleshoot?

Thanks.