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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
