AcuSQL parse error when trying to call a stored procedure.

I am trying to use a cursor to read a stored procedure, but get "parse error at :ret-code" on the following declare:

EXEC SQL
DECLARE FpReportIdCursor CURSOR FOR
:ret-code = exec
CBM.dbo.FileProcessingReportDetail_SelectByReportID
(:ws-report-id)
END-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.

Thanks,
Steve

Parents Reply Children
No Data