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 [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:maheswara.rao@;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: [EMAIL PROTECTED] 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: [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).
