Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Can you please help me by giving an example ......

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US