Re: How to call a private package level function

I figured it out.

If I want a function or a procedure to be private, I just add it to the body of the package. But note: The private function must be declared before any code that calls it!

create or replace package test
is

        FUNCTION MYPUBLICFUNC (parm in integer) return INTEGER; end;
/
create or replace package body test
AS

• MUST Declare HERE FUNCTION MYPRIVATEFUNC (parm in integer) return integer IS BEGIN RETURN 3*parm; END;

	FUNCTION MYPUBLICFUNC (parm in integer)
	return integer
	IS
	BEGIN
		RETURN test.MYPRIVATEFUNC(parm);
	END;



	-- MUST NOT DECARE HERE!!

END; Regards Mat Received on Sat Aug 14 2004 - 14:54:55 CDT