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

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

Original text of this message