How to call a private package level function
From: M <hess2203_at_hotmail.com>
Date: 13 Aug 2004 07:35:41 -0700
Message-ID: <c45531b7.0408130635.7016bd9e_at_posting.google.com>
Hello
END;
Date: 13 Aug 2004 07:35:41 -0700
Message-ID: <c45531b7.0408130635.7016bd9e_at_posting.google.com>
Hello
I am trying to build an Oracle PL/SQL Package. Some functions should only be visible from the package, while other functions need to be called from outside.
I tried the following:
- begin code snippet ---
create or replace package test
is
FUNCTION MYPUBLICFUNC (parm in integer) return INTEGER;
end;
/
create or replace package body test
AS
FUNCTION MYPUBLICFUNC (parm in integer) return integer IS BEGIN RETURN test.MYPRIVATEFUNC(parm); END; FUNCTION MYPRIVATEFUNC (parm in integer) return integer IS BEGIN RETURN 3*parm; END;
END;
- End Code snippet ---
This results in an Error Message:
PLS-00013: MYPRIVATEFUNC ist für diesen Geltungsbereich nicht
definiert.
What am I doing wrong here ??
Kind Regards
Mat Hess
Please reply to the newsgroup Received on Fri Aug 13 2004 - 16:35:41 CEST