Easy one. The function declaration does not match between the spec and the body.
function check_OK (n1 in number)
function check_ok (nn in number)
Argument names must be the same.
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan
[EMAIL PROTECTED]
To: [EMAIL PROTECTED]
10/21/2002 01:43 cc:
PM Subject: What is wrong with this
package? Pls. help
Please respond to
ORACLE-L
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
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Thomas
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).
