Package is compiled once in the database and hence accessing an object fro

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

Question Posted / kiran

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

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to start your 10g xe server?

970

Please explain compound trigger in oracle?

996

How does Oracle guarantee data integrity of data changes?

2333

How do I escape a reserved word in oracle?

1132

How to create a stored function in oracle?

1040

How to create a new tablespace in oracle?

934

How to select an oracle system id (sid)?

1020

What is difference between truncate and delete?

977

How to check the oracle tns settings?

991

How to retrieve values from data fields in record variables?

1036

How to create additional tablespaces for an new database?

970

How to use "in" parameter properly?

1006

How to define an anonymous procedure with variables?

1065

What happens to the current transaction if the session is ended?

1037

How to define an explicit cursor in oracle?

989