Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Cant find anything wrong with this code but it still errors

Cant find anything wrong with this code but it still errors

From: Dwight Crane <dwight.crane_at_mci.com>
Date: Thu, 27 Aug 1998 13:56:59 -0400
Message-ID: <54hF1.1064$fG.435857@news.mci2000.com>


Ok.. below is my code which appears to me to be flawfless... BUT

this is the call of the function

LERG_CLLI(recMatch.LEC_NPA, recMatch.LEC_NXX, recMatch.MCI_NPA, recMatch.MCI_NXX)

the following section is the function the above calls....

FUNCTION LERG_CLLI(sLECNPA IN VARCHAR2, sLECNXX IN VARCHAR2,sMCINPA IN VARCHAR2, sMCINXX IN VARCHAR2) RETURN VARCHAR2 IS RET_LERG_CLLI VARCHAR2(11);    BEGIN
       SELECT LEC_SWTCH_CLLI INTO RET_LERG_CLLI     FROM CIS_COLLO_T
    WHERE (LEC_NPA = sLECNPA) AND
(LEC_NXX = sLECNXX) AND
(MCI_NPA = sMCINPA) AND
(MCI_NXX = sMCINXX);

   RETURN RET_LERG_CLLI;
END; this is the ERROR message I get...

(1):PLS-00306: wrong number or types of arguments in call to 'LERG_CLLI'

I do not see how this is an error????
Dwight
dwight.crane_at_mci.com Received on Thu Aug 27 1998 - 12:56:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US