PLS-00323: subprogram or cursor... really wierd
I'm not sure where I'm causing this error, here is the pkg spec & body... but if i remove v_end_date from spec & body, then this pkg compiles fine...
Here is the error message:
PLS-00323: subprogram or cursor 'my_fn' is
declared in a package specification and must be defined in the
package body
Package Spec
----------------------
CREATE OR REPLACE PACKAGE Pkg_Rep IS
FUNCTION my_fn ( v_app_id IN NUMBER, v_report_no IN NUMBER, v_prop_id IN NUMBER, v_start_dt IN DATE, v_end_dt IN DATE) RETURN number;
END Pkg_Rep;
/
Package Body
---------------------
CREATE OR REPLACE PACKAGE BODY Pkg_Rep AS
FUNCTION my_fn ( v_app_id IN NUMBER, v_report_no IN NUMBER, v_prop_id IN NUMBER, v_start_dt IN DATE, v_end_date IN DATE)
RETURN number IS
BEGIN
....
END my_fn;
END Pkg_Rep;
/