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).
