package compilation problem

From: Vijaya Chander V.S <srinivasa_v_at_infosys.com>
Date: Sat, 22 Jun 2002 09:11:48 -0800
Message-ID: <F001.00484BBA.20020622091148@fatcity.com>

I am having a package compilation problem . The package is like below

CREATE OR REPLACE PACKAGE PKG_POSNS_TEST as

    TYPE cur_acct_checking_posn is REF CURSOR;                 

    PROCEDURE CHECKING_ACCT_POSN_TEST(

	in_position_as_of_date IN BUSY_DAY.RPT_DT%TYPE,
	out_rcur_acct_noninvst_posn OUT cur_acct_checking_posn,
	out_error_code OUT VARCHAR2);

END PKG_POSNS_TEST;
/

CREATE OR REPLACE PACKAGE BODY PKG_POSNS_TEST as PROCEDURE CHECKING_ACCT_POSN_TEST(

	in_position_as_of_date IN BUSY_DAY.RPT_DT%TYPE,
	out_rcur_acct_noninvst_pos OUT cur_acct_checking_posn,
	out_error_code OUT VARCHAR2)

AS
BEGIN     OPEN out_rcur_acct_noninvst_pos FOR

	SELECT DISTINCT
	    P.ACCT_KEY,
	    P.POSN_AS_OF_DT,
	    P.POSN_PRD_TYPE_CD,
	    P.POSN_SEQ_NBR,


	    ' ' AS DESCRIPTION,

	    A.ACCT_NBR as ACCTNUM,
	    P.CURR_YLD_PCT AS YIELD,
	    P.NOM_ACCR_INT_AMT,


	    ' ' AS INTPAIDYTD, -- not available in database.

	    P.NOM_UNT AS OPENINGBAL, 
	    (P.NOM_UNT+P.NOM_ACCR_INT_AMT) AS ACCTBAL,


	    ' ' AS UNCLFUND, -- not available in database.

	    (P.NOM_UNT+P.NOM_ACCR_INT_AMT) AS PREVMENDACCTBAL, -- is this correct or should it be for previous monthend.
	    A.ACCT_OPEN_DT AS ACCTOPENDT,
	    P.ANL_PCT_RT AS ANLPCTRT,


	    ' ' AS INTFREQ, -- not available in database.

	    (P2.NOM_UNT+P2.NOM_ACCR_INT_AMT) AS CHKPLUSBAL
	FROM	POSN P,
		POSN P2, -- for Checking plus
		ACCT_PORTFOLIO A
	WHERE	A.ACCT_KEY IN (1,2,3)
	  AND   A.ACCT_KEY = P.ACCT_KEY
	  AND   P.ASSET_SUB_CLAS_CD = 'CH' -- Checking
	  AND   P.POSN_AS_OF_DT = in_position_as_of_date
	  AND   P.ACCT_KEY(+) = P2.ACCT_KEY
	  AND   P.ASSET_SUB_CLAS_CD = 'CHKPLU' -- Checking Plus
	  AND   P.POSN_AS_OF_DT = in_position_as_of_date
	ORDER BY DESCRIPTION;
    EXCEPTION
    	WHEN NO_DATA_FOUND THEN
	    CLOSE out_rcur_acct_noninvst_pos;
	    out_error_code := SQLCODE;
        WHEN OTHERS THEN
	    CLOSE out_rcur_acct_noninvst_pos;
	    RAISE_APPLICATION_ERROR (-20000, SQLCODE || SQLERRM);

END; END PKG_POSNS_TEST;
/

the error it is giving is

PLS-00323: subprogram or cursor 'CHECKING_ACCT_POSN_TEST' is declared in a package specification and must be defined in the package body

can anyone help,

vijay

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Vijaya Chander V.S
  INET: srinivasa_v_at_infosys.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Sat Jun 22 2002 - 12:11:48 CDT