Friday, March 30, 2012

How do I make a function private?

Hi,
Am just wondering how to make a function private within a package??
FUNCTION get_new_student_id
Thanks.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;
/|||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

No comments:

Post a Comment