Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Can you please help me by giving an example ......
Ramu wrote:
> Hai,
>
> Please help me by giving a suitable example for creating a package in
> oracle(Including functions and procedures in it) and how can we use
> it....Thanking you a lot
>
Define suitable...
I cannot judge what would be suitable for you
One would use a package in order to:
- speed up loading time (you load the package, i.e. all code) - create logical units (maintenance!) - force standards (package header used to define standards) - encapsulate and/or hide code (local procedures/functions, wrap)
More on PL/SQL here:
http://www.oracle.com/pls/db102/to_pdf?pathname=appdev.102%2Fb14261.pdf&remark=portal+%28Getting+Started%29
This might also be helpful, the Application Deveopers guide:
http://www.oracle.com/pls/db102/to_pdf?pathname=appdev.102%2Fb14251.pdf&remark=portal+%28Books%29
-- Regards, Frank van Bortel Top-posting is one way to shut me up...Received on Thu Feb 16 2006 - 10:40:52 CST
![]() |
![]() |