macca

 Profile Answers by macca 

• Mar 4th, 2009

 

Stand Alone Procedure is not part of an Package.

ayansmile07

 Profile Answers by ayansmile07 

• Mar 23rd, 2010

 

These are the 4 differences between a Stand Alone Procedure and a Packaged Procedure

Creation - A standalone procedure is created using the CREATE PROCEDURE statement. A packaged procedure is created as part of the package body’s definition.

Memory - Oracle caches standalone procedures in memory by themselves, but packaged procedures must be stored and cleared from memory with the rest of the package.

Execution - Packaged procedures must be qualified by the package name to be executed by objects that aren’t contained within the package.

Scope - Packaged procedures can reference other constructs and objects within the same package without qualifying the reference with a package name.