Oracle Package.function

Hi,

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


Regards
Sanjay

the entire package definition will get loaded

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

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=Yajnas;10525]Hi,

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


Regards
Sanjay[/QUOTE]

[QUOTE=Yajnas;10525]Hi,

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


Regards
Sanjay[/QUOTE]
Everything of the package including its variables, all procedures etc.

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