Progress
SQL-89
Guide and Reference
Cursors Within Internal Procedures
Cursors within internal procedures are supported by the provision of two cursor styles:
- The DECLARE CURSOR statement is in the main procedure, and all other statements that refer to the cursor, such as OPEN, FETCH, UPDATE, DELETE and CLOSE, are in the main procedure or any subprocedures.
The only restriction is that the DECLARE CURSOR statement must compile (that is, occur in the source file) before any other statement that refers to the cursor.
- The DECLARE CURSOR statement and all other statements that refer to the cursor are in a single internal procedure.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |