OraFAQ Forum: SQL & PL/SQL » disadvantage of package in pl/sql

Home » SQL & PL/SQL » SQL & PL/SQL » disadvantage of package in pl/sql

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

disadvantage of package in pl/sql [message #257843]

Thu, 09 August 2007 06:00

subhadip.chanda
Messages: 64
Registered: May 2007

Member

Can one tell me what is the disadvantage of package in pl/sql?

Report message to a moderator

Re: disadvantage of package in pl/sql [message #257846 is a reply to message #257843]

Thu, 09 August 2007 06:08

Maaher
Messages: 7065
Registered: December 2001

Senior Member

None that I can think of.

MHE

Report message to a moderator

Re: disadvantage of package in pl/sql [message #257848 is a reply to message #257846]

Thu, 09 August 2007 06:14

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.

Report message to a moderator

Re: disadvantage of package in pl/sql [message #257854 is a reply to message #257843]

Thu, 09 August 2007 06:25

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

...But there are many advantages...

Regards
Michel

Report message to a moderator

Re: disadvantage of package in pl/sql [message #257874 is a reply to message #257854]

Thu, 09 August 2007 07:07

Maaher
Messages: 7065
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 05 16:25:49 CST 2024