i have procedure p1.and also i declare the same procedure in a package. whice on

i have procedure p1.and also i declare the same procedure in a package. whice one is efficient package procedure or procedure?

Question Posted / guest

2 Answers
5130 Views
Microsoft, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

i have procedure p1.and also i declare the same procedure in a package. whice one is efficient packa..

Answer / kiran

Package is compiled once in the database and hence accessing
an object from a Package.procedure is more efficient than
Stored procedure as the object is Pinned to the DB unlike
the normal Stored procedure, again the core crux of the
project will make the choice.

Is This Answer Correct ?

2 Yes

2 No

i have procedure p1.and also i declare the same procedure in a package. whice one is efficient packa..

Answer / suresh babu

The procedure,which we defined with in package,will be very
powerful,once we call the package it will load all
procedures and functions dynamically.so we can access more
number of procedures with out calling again and again.

But we can't call multiple procedures in single time.If we
want to access multiple procedures,which we didn't defined
with in package,isn't possible.we can call those procedures
one by one.

So the procedure,which we defined with in package, is very
powerful than the procedure,which we didn't defined with in
package.

Is This Answer Correct ?

0 Yes

2 No

Post New Answer