But I only obtain an error when I execute a stored procedure through connection ODBC:
ERROR [42000] [MySQL MaxDB][SQLOD32 DLL][MaxDB] Syntax error or access violation;-3005 POS(1) Invalid SQL statement
The syntax for calling stored procedures is CALL <dbproc_name> [(<expression>,...)] http://www.mysql.com/documentation/maxdb/a7/41ee17605911d3a98800a0c9449261/frameset.htm
create dbproc MyNewData AS SELECT * FROM MyTable
see http://www.mysql.com/documentation/maxdb/a7/41ee11605911d3a98800a0c9449261/frameset.htm
about the details of creating stored procedures that return cursors.
Daniel Dittmar
-- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED]
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
