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.