[iknownothing]

Hi,

Am just wondering how to make a function private within a package??

FUNCTION get_new_student_id

Thanks.

[andrewst]

Simply leave the function out of the package specification:

CREATE OR REPLACE PACKAGE pkg IS
PROCEDURE public_proc;
END;
/

CREATE OR REPLACE PACKAGE BODY pkg IS

-- This procedure is private: it can only be called from within the package
PROCEDURE private_proc IS
BEGIN
NULL;
END;

PROCEDURE public_proc IS
BEGIN
private_proc;
END;

END;
/

[joebednarz]

In case you're interested... you can also do this within a procedure.

CREATE OR REPLACE PROCEDURE INET.show_test
IS

   FUNCTION my_test (a VARCHAR2)
   RETURN VARCHAR2
   IS
   BEGIN
      RETURN a;
   END;

BEGIN

   dbms_output.put_line( my_test('b') );

END;

JoeB