I am trying to use a cursor to read a stored procedure, but get "parse error at :ret-code" on the following declare:
DECLARE FpReportIdCursor CURSOR FOR
:ret-code = exec
I assume I am missing something on the exec line but the syntax above is just like the example in the manual.
I use cursors in AcuSQL to read tables with no problem but this is my first attempt at a stored procedure.
The manuals example gets the same parse error when I try to compile it.
There are several similar questions on this forum but no answers.
Any help would be appreciated.