set echo on
-- *** @RetrieveCourse.sql ***
-- *** NOTE: Logon using the student schema ***
spool RetrieveCourse.txt
-- ***
-- *** Create script for PACKAGE: RetrieveCourse ***
-- ***

CREATE OR REPLACE PACKAGE pkg_CourseList AS

  TYPE recCourse IS RECORD (
    vCourseDesc   Course.Description%TYPE,
    vCourseCost   Course.Cost%TYPE
  );
  
  TYPE curCourseList IS REF CURSOR RETURN recCourse;
  
  PROCEDURE sp_getCourseList (
    rsCourses OUT curCourseList
  );
END pkg_CourseList;
/
CREATE OR REPLACE PACKAGE BODY pkg_CourseList AS

  PROCEDURE sp_getCourseList (
    rsCourses OUT curCourseList
  )
  AS
  BEGIN
    OPEN rsCourses FOR
      SELECT
        course.DESCRIPTION,
        course.COST
      FROM course;
  END sp_getCourseList;
  
END pkg_CourseList;
/
    
-- ********************* VERIFY PACKAGE ****************************
set echo off
set pages 80
set lines 80
set heading on
column line format 9999
column name format a20
column object_name format a20
column object_type format a15
column position format 9999
column status format a10
column text format a30
--
select object_name, object_type, status
   from user_objects
   where object_name =
      (UPPER('pkg_CourseList')) ;
set echo on
-- ********************* CHECK ERROR FILE **************************
set echo off
select name, line, position, text
   from user_errors
   where name =
      (UPPER('pkg_CourseList')) ;
spool off

...
.
PACKAGE pkg_CourseList compiled
...
.
PACKAGE BODY pkg_CourseList compiled
> -- ********************* VERIFY PACKAGE ****************************
OBJECT_NAME          OBJECT_TYPE     STATUS  
-------------------- --------------- ----------
PKG_COURSELIST       PACKAGE         VALID     
PKG_COURSELIST       PACKAGE BODY    VALID     

> -- ********************* CHECK ERROR FILE **************************
no rows selected

Error starting at line 1 in command:
EXEC pkg_CourseList
Error report:
ORA-06550: line 1, column 7:
PLS-00221: 'PKG_COURSELIST' is not a procedure or is undefined
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
06550. 00000 -  "line %s, column %s:\n%s"
*Cause:    Usually a PL/SQL compilation error.
*Action:

SQL> create or replace procedure curtest (a out sys_refcursor) as
  2  begin
  3  open a for select 1 from dual;
  4  end;
  5  /

Procedure created.

SQL> var x refcursor
SQL> exec curtest(:x);

PL/SQL procedure successfully completed.

SQL> print :x

         1
----------
         1

SQL> 

(
    rsCourses OUT curCourseList
  );

select package.PROCEDURE from dual

select package.FUNCTION from dual

begin
  package.PROCEDURE;
end;