prasads_delight1

 Profile Answers by prasads_delight1 Questions by prasads_delight1

• Sep 27th, 2007

 

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.

amikat

 Profile Answers by amikat 

• Jun 3rd, 2008

 

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

suresh.adqr

 Profile Answers by suresh.adqr 

• Feb 18th, 2009

 

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.