what is the difference difference between procedure and packages

what is the difference difference between procedure and
packages

Question Posted / gavini srikanth

2 Answers
9458 Views
3i Infotech, Oracle, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is the difference difference between procedure and packages..

Answer / kanchan kumari

procedure is named pl/sql block which is used by
programmer to perform any task these type of block exist in
database physically.

package is also named pl/sql block which is associated
with pl/sql variable, view, sub programs.
package can't be invoked
in other word we can say that package can contain more than
one procedure, function etc.but procedure can't

Is This Answer Correct ?

7 Yes

1 No

what is the difference difference between procedure and packages..

Answer / rajesh venati

A Procedure is a Named Pl/Sql program. Procedures are used
for to perform a particular task. Overloading concept is not
allowed in standard alone procedures.

Then go for Packages, package is grouping the collection of
database objects like procedures, functions, type, variable,
cursors and exception etc... Here overloading concept is
valid, we can define same name for database objects with
different type of parameters or data types.....

I believe this is useful.................

Is This Answer Correct ?

4 Yes

0 No

Post New Answer