Oracle PL/SQL - Cursor Variable with User-Defined Return Type

  1. HOME
  2. Oracle PL/SQL
  3. PL SQL Cursor
  4. Cursor Variables

Introduction

In the following code, return_type is a user-defined RECORD type.

Demo

SQL>
SQL> DECLARE-- from ww w.  ja  va2s.co  m
  2    TYPE EmpRecTyp IS RECORD (
  3      empid NUMBER,
  4      last_name VARCHAR2(25),
  5      salary   NUMBER(8,2));
  6
  7    TYPE EmpCurTyp IS REF CURSOR RETURN EmpRecTyp;
  8    emp_cv EmpCurTyp;
  9  BEGIN
 10    NULL;
 11  END;
 12  /

PL/SQL procedure successfully completed.

SQL>

Related Topic