cchap6_hrreatebody.gif shows the SQL Worksheet in SQL Developer.
The Enter SQL Statement pane contains the statements
CREATE OR REPLACE PACKAGE BODY cv_types AS PROCEDURE get_employees(deptid in number, employees in out empinfotyp) IS BEGIN OPEN employees FOR SELECT employee_id, substr(first_name,1,1) || '. '|| last_name as employee_name, hire_date, to_char(salary, '999G999D99') as salary,
The Results pane contains the message
Package Body Compiled.