Home » SQL & PL/SQL » SQL & PL/SQL » lot of packages?
lot of packages? [message #746] Fri, 01 March 2002 05:18 Go to next message
monir
Messages: 22
Registered: February 2002
Junior Member
there is any one can tell me what is the difference
between creating one package for a group of procedures and one package for each procedure
and what is the advantages between each solution
thanks
Re: lot of packages? [message #747 is a reply to message #746] Fri, 01 March 2002 05:32 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
when the package is loaded into memory ,all the procedure is loaded within it at once.so it is better idea to put related procedure to one package, avoiding more i/o operation. and the same time the procedure within the package can share package variable.
Previous Topic: Dynamic From Statement in PL/SQL
Next Topic: Re: Rownum problem in Oracle 7
Goto Forum:
  


Current Time: Fri Apr 19 23:47:33 CDT 2024