Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PLS-00323: subprogram or cursor... really wierd

tech_usrJun 5 2006 — edited Jun 5 2006
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;
/
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 3 2006
Added on Jun 5 2006
2 comments
4,352 views