i have procedure p1.and also i declare the same procedure in a package. whice one is efficient package procedure or procedure?
- 2 Answers
- 4749 Views
- Microsoft, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
What are the different types of partitions in oracle?
What is a directory object?
What are the oracle built-in data types?
what is the difference between no rows returned and null returned?
How to create a stored function in oracle?
What are the different editions of oracle?
Difference between inner join vs where ?
i have procedure p1.and also i declare the same procedure in a package. whice one is efficient package procedure or procedure?
23. Display the client name for all clients who have placed an order where any order line has more than 3 items. Do not use a table join anywhere in your query.
What is cluster Key ?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
What is a package ? What are the advantages of package ?
Oracle General 
