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?

Thanks.

Options: ReplyQuote


Subject
Views
Written By
Posted
Why the error?
3716
July 19, 2004 03:52PM
2638
July 19, 2004 03:57PM
2480
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.