How do I make a function private?

iknownothing · #1 (**permalink**) 12-02-03, 05:44

Hi,

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

FUNCTION get_new_student_id

Thanks.

andrewst · #2 (**permalink**) 12-02-03, 08:54

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 · #3 (**permalink**) 12-11-03, 16:13

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

Code:

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

Internet Services

Web Development

Digital Marketing

Consumer Tech