Results 1 to 6 of 6

Thread: Oracle package question

  1. #1
    Junior Member
    Join Date
    Nov 2006
    Answers
    1

    Oracle package question

    Could some one explain me the reason to use Packages as opposed to procedures..


  2. #2
    Contributing Member
    Join Date
    Jun 2006
    Answers
    95

    Re: Oracle package question

    you can combine multiple procedures in to one package .... it's just a way for organizing related procedures in to one group....


  3. #3
    Expert Member
    Join Date
    Jun 2006
    Answers
    410

    Re: Oracle package question

    some other advantanges of using packages are

    1. You can have global variables in a package which can be used by all the procedure/functions in the package.

    2. If a procedure/function of a package is called then the entire package will be loaded in the main memory. This improves performance.


  4. #4
    Expert Member
    Join Date
    Sep 2006
    Answers
    130

    Re: Oracle package question

    There is another advantage on using packages instead of procedure is Overloading.
    With packages, u can overload procedures & functions, which means u can create multiple subprograms with the same name in the same package, each taking parameters of different number or datatype. Whereas the same feature is not possible for procedures or functions.

    *** Innila ***

    Last edited by Innila; 02-20-2007 at 05:54 AM.

  5. #5
    Junior Member
    Join Date
    Mar 2006
    Answers
    1

    Re: Oracle package question

    If we use the Global Variables in a Packages, that variables are session based or not??


  6. #6
    Expert Member
    Join Date
    Sep 2006
    Answers
    130

    Re: Oracle package question

    Global variables in a package are session based.
    You can declare global (public) variables that exist for the duration of the user session.

    *** Innila ***

    Last edited by Innila; 02-20-2007 at 05:56 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact