Re: What is wrong with this package? Pls. help

maheswara.rao_at_sungard.com wrote:
>
> When we compile this package body, we are getting the error - PLS -
> 00323. Please help.
>
> Platform: Solaris 7. Oracle 8.1.6.
>
> Package is getting created without any errors.
>
> When we try to compile package body we are getting the error
> 3/12 PLS-00323: subprogram or cursor 'CHECK_OK' is declared in a
> package specification and must be defined in the package body
>
> Package:
>
> CREATE OR REPLACE PACKAGE P1 is
> msg_g number(3);
> function check_OK (n1 in number)
> return number;
> procedure test;
> end p1;
>
> create or replace package body p1 as
> function check_ok (nn in number) return number
> IS
> KK number;
> BEGIN
> KK := msg_g * nn;
> return KK;
> end check_ok;
> procedure test as
> v1 number;
> begin
> null;
> end test;
> end p1;
> /
>
> Thanks,
>
> Rao
> --

Rao,

   Replace n1 with nn in the package part and it will work like a charm. PL/SQL is _very_ stupid and prameters must bear the same names in specifications and actual declaration, even if doesn't make much sense. I always use cut-and-paste :-).

-- 
Regards,

Stephane Faroult
Oriole Software
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriole.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).