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

Rao,

You've defined the package to use "n1" as a parameter to "CHECK_OK", but "nn" in the body. Make them match and all should be well.

HTH! :) Rich

Rich Jesse                           System/Database Administrator
Rich.Jesse_at_qtiworld.com              Quad/Tech International, Sussex, WI USA

> -----Original Message-----
> From: maheswara.rao_at_sungard.com [mailto:maheswara.rao_at_sungard.com]
> Sent: Monday, October 21, 2002 3:43 PM
> To: Multiple recipients of list ORACLE-L
> Subject: What is wrong with this package? Pls. help
>
>
> 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;
> /

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: Rich.Jesse_at_qtiworld.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).