Home » SQL & PL/SQL » SQL & PL/SQL » disadvantage of package in pl/sql
disadvantage of package in pl/sql [message #257843] Thu, 09 August 2007 06:00 Go to next message
subhadip.chanda
Messages: 64
Registered: May 2007
Member
Can one tell me what is the disadvantage of package in pl/sql?
Re: disadvantage of package in pl/sql [message #257846 is a reply to message #257843] Thu, 09 August 2007 06:08 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
None that I can think of.

MHE
Re: disadvantage of package in pl/sql [message #257848 is a reply to message #257846] Thu, 09 August 2007 06:14 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
You have to type a bit more, as you put <package_name> in front of all the procedure and function calls.

Other than that, no disadvantages I can think of.
Re: disadvantage of package in pl/sql [message #257854 is a reply to message #257843] Thu, 09 August 2007 06:25 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
...But there are many advantages...

Regards
Michel
Re: disadvantage of package in pl/sql [message #257874 is a reply to message #257854] Thu, 09 August 2007 07:07 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
One could argue that a package is loaded as a whole and when you only need a small procedure from a large package there's a lot of memory used. But I think that's a false argument. After all, it is the development team that groups the procedures in packages.

MHE
Previous Topic: Need some arithmatic help for this one
Next Topic: read txt file and update into db
Goto Forum:
  


Current Time: Tue Dec 06 16:12:23 CST 2016

Total time taken to generate the page: 0.12012 seconds