In ORACLE, To create a cursor variable, you define a REF CURSOR type, then declare cursor
variables of corresponding type.
Declaring REF CURSOR Type and Cursor Variables, passing Cursor Variables As Parameters can be declared in a PL/SQL.
A REF CURSOR is commonly declared in the ORACLE package and use it as a OUT PARAMETER of the ORACLE PL/SQL.
However, in case of the ALTIBASE HDB, Since it doesn't provide a package functionality currently, Typeset should be created in advance, and use it.
The use of REF CURSOR
The procedures to use REF CURSOR should be divided into plural categories in ALTIBASE HDB as follows.
- Create the user-defined type which is a REF CURSOR, and create a typeset which containing a corresponding type
- Create the stored procedure, which having OUT parameters.
- Execute a procedure.
TYPE and TYPESET
Since ALTIBASE HDB doesn't provide a package functionality, Once a typeset is created with user-defined type, it can be passed between procedures.
Thus, a typeset, a combination of user-defined types using "CREATE TYPE" statement, can be made using "CREATE TYPESET" statement.
If you wish to see further about the method of passing result set which described above in detail, refer to this page(Cursor Variables)
CREATE OR REPLACE PACKAGE ref_cursor_pkg AS
CREATE OR REPLACE TYPESET my_type
In ORACLE, A declaration of the type is possible