chap6_hrcreatepack.gif shows SQL Worksheet in SQL Developer.

The Enter SQL Statement pane 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;

The Results pane contains the message

Package cv_types Compiled.