Description of the illustration chap6_refcursor

chap6_refcursor_001.gif shows the top of the SQL Commands page.

The Oracle Database XE logo appears on the left side of the header. Home, Logout, and Help icons appear in the right side of the header. The current user, HR, is displayed under the logo.

Horizontal lines separate the header and body content. Immediately under the separator, a navigation breadcrumb appears on the left side, and a schema list field appears on the right side. The navigation breadcrumb displays Home > SQL > SQL Commands. The schema currently selected is HR.

The majority of the body is taken up by the editor pane. It contains the statements

CREATE OR REPLACE PACKAGE cv_types AS
  TYPE empinfotyp IS REF CURSOR;
  PROCEDURE get_employees(deptid in number,
                          employees in out empinfotyp);
END cv_types;

Immediately above the editor pane are the following:

Autocommit check box, which is checked.
Display list, which shows the value 10.
Save and Run buttons. The mouse cursor is on the Run button.