procedures package

[AdusumalliGopikumar]

Procedure also stored in database and package also stored in a database,

we can call the procedure to do the task ,

and same one using package.procedure name if it exists in that package.


my question is why we need a package.procedure as we can get the result by calling the procedure directly if we already created that procedure?


why package.procedure..............

[debasisdas]

Inside a package we can define a number of procedures and functions .
If we call any member of the package all others are automatically loaded into memory. Nexttime we call any other memeber it will be accessed from memory.

If u want to go for overloading we have to use packages.

[amitpatel66]

Packages can alsoe be use to provide security.

1. One need to know only the packge and the procedure within the package that can be used to achieve some functionality rather worrying about how this functionality is achieved within PROCEDURE source code.

2. Packages also helps making use of a variable,CONSTANTS declared within a packge to be used among all the procedures declared within a package spec.