Re: How to call a private package level function

Not quite true. You can use a forward declaration in order to keep the sub-programs in the order you require:

create or replace package test
is

        FUNCTION MYPUBLICFUNC (parm in integer) return INTEGER; end;
/

create or replace package body test
AS

   FUNCTION myprivatefunc(parm IN INTEGER) RETURN INTEGER;

	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;
/
Received on Mon Aug 16 2004 - 06:18:48 CDT