Re: Can you please help me by giving an example ......

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Thu, 16 Feb 2006 17:40:52 +0100
Message-ID: <dt297c$1ac$1@news4.zwoll1.ov.home.nl>

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