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