Basics - What is the different between Stand Alone Procedure and Package?

GeekInterview.com > Interview Questions > Oracle > Basics

Go To First | Previous Question | Next Question

Basics | Question 39 of 49

What is the different between Stand Alone Procedure and Package?

Total Answers and Comments: 3

Last Update: February 18, 2009 Asked by: ttparavindh

Sponsored Links

Best Rated Answer

—

Submitted by: amikat

Procedure is a named PL/SQL block tht is stored in the database.
Package is a collection of functions and procedures stored within the database.
Pkg consists of 2 parts
1. Specification - declares types,functions,procedures,exceptions,cursors
2. Body - implements the specification
Whenevr a func/proc is referenced from the pkg thn the entire pkg is loaded in the memory so tht whn a diff func from the same pkg is referenced thn its already there in the memory

Above answer was rated as good by the following members:
saginandkishore, ane_esh_k

September 27, 2007 22:40:29

prasads_delight1

Member Since: August 2007 Contribution: 9

RE: What is the different between Stand Alone Procedur...

Procedure is an important concept in PL/SQL. The sophisticated business rules and application logics are stored in Procedures.

The Packages are the collection of procedures fuctions variables and SQL command statements The packages allow multiple procedures to use same variable and coursors. The collection of procedures can be execute as per the sequence generated in the logic for package construction.

Important is to execute a procedure with in a package first we must list the package name followed by the procedure name.

Is this answer useful? Yes | No

0 2

Overall Rating: -2

June 03, 2008 14:02:08

amikat

Member Since: June 2008 Contribution: 5

RE: What is the different between Stand Alone Procedure and Package?

Procedure is a named PL/SQL block tht is stored in the database.
Package is a collection of functions and procedures stored within the database.
Pkg consists of 2 parts
1. Specification - declares types functions procedures exceptions cursors
2. Body - implements the specification
Whenevr a func/proc is referenced from the pkg thn the entire pkg is loaded in the memory so tht whn a diff func from the same pkg is referenced thn its already there in the memory

Is this answer useful? Yes | No

2 0

Overall Rating: +2

February 18, 2009 04:39:23

suresh.adqr

Member Since: November 2008 Contribution: 1

RE: What is the different between Stand Alone Procedure and Package?

1. Procedure Overloading and Function Overloading Possible in Package. This Overloading Concept Not Possible in Procedure.
2. Variables in Package we Can use as a Global Variables. it's Not Possible in Procedure.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank