Results 1 to 6 of 6

Thread: Oracle Package.function

  1. #1
    Junior Member
    Join Date
    Apr 2007
    Answers
    16

    Exclamation Oracle Package.function

    Hi,

    Can any one please reply back the answer to the question that " If u call a package.function name then what will get loaded in memory?".


    Regards
    Sanjay


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

    Re: Oracle Package.function

    the entire package definition will get loaded


  3. #3
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074

    Re: Oracle Package.function

    It will load all the members of the package in to memory.


  4. #4
    Junior Member
    Join Date
    Dec 2008
    Answers
    1

    Re: Oracle Package.function

    The whole package (all members in the package) is loaded into the memory. That's why calling of packeged members being executed fast while calling of any members, second time.



    Quote Originally Posted by Yajnas View Post
    Hi,

    Can any one please reply back the answer to the question that " If u call a package.function name then what will get loaded in memory?".


    Regards
    Sanjay



  5. #5
    Junior Member
    Join Date
    Jan 2009
    Answers
    2

    Re: Oracle Package.function

    Quote Originally Posted by Yajnas View Post
    Hi,

    Can any one please reply back the answer to the question that " If u call a package.function name then what will get loaded in memory?".


    Regards
    Sanjay
    Everything of the package including its variables, all procedures etc.


  6. #6
    Expert Member
    Join Date
    Nov 2008
    Answers
    300

    Re: Oracle Package.function

    All the objects in the package will get loaded in to the memory. Variables, methods,types


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