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