MySQL Forums
Forum List  »  Stored Procedures

Why the error?
Posted by: victor nunez
Date: July 19, 2004 03:52PM

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?


Options: ReplyQuote

Written By
Why the error?
July 19, 2004 03:52PM
July 19, 2004 03:57PM
July 21, 2004 05:02AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.