Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Location
    Ireland
    Posts
    10

    Unanswered: 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.

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: How do I make a function private?

    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;
    /

  3. #3
    Join Date
    Dec 2003
    Location
    Oklahoma, USA
    Posts
    354
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •