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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment