Subject Re: [firebird-support] DECLARE MyCursor CURSOR
Author Martijn Tonies
Hello Robert,

> I have the "Interbase 6 Data Definition Guide" and that is where DECLARE,
> OPEN, FETCH, and CLOSE CURSOR is discussed. I just can't find anything

Not for procedural SQL. These are all about "embedded SQL".

> regarding them in Firebird 1.5. According to Carlos H. Cantu, I'll have
> wait until Firebird 2.0 before there is full CURSOR support. I already
> the FOR SELECT method, but I need to be able to put the DECLARE, OPEN in
> stored procedure, the FETCH in another stored procedure, and CLOSE in yet
> another. Something I should be able to do since the named CURSOR remains
> live until specifically CLOSEd.

Well, currently, you cannot.

And having a cursor across procedure boundaries might be a different
story altogether.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Upscene Productions