Oracle Discussion Forums
Welcome, Guest. Please login or register.
September 10, 2010
Home Help Search Login Register
News:


+  WebForums - OraclePassport
|-+  IT progamming - Oracle, Java, Unix, MySQL, Toad
| |-+  Oracle -Triggers, Exceptions, Procedures
| | |-+  Oracle Packages, Procedures, Functions
| | | |-+  Whats the difference between a standalone and packaged procedure?		 0 Members and 1 Guest are viewing this topic. « previous next »
Pages: [1] Go Down Send this topic Print
Author Topic: Whats the difference between a standalone and packaged procedure?  (Read 507 times)
dtech-team
Administrator
Assistant Professor
*****

Appreciate? +5/-0
Offline Offline

Posts: 616


DTecH Oracle Forums

WWW
« on: May 20, 2010 »
Whats the difference between a standalone and packaged procedure?
Report to moderator   Logged

DTecH Admin Team
Buy Oracle Interview Preparations Kit from DTecH IT Education - 250 Oracle Interview Questions and Answers.
dtech-team
Administrator
Assistant Professor
*****

Appreciate? +5/-0
Offline Offline

Posts: 616


DTecH Oracle Forums

WWW
« Reply #1 on: May 20, 2010 »
1. Main difference would be "Overloading" !! - Procedure/Function overloading.

2. Packaged procedure is grouped along with logically related procedures/functions - modularity.
    =>less  communication time- run faster when called by other procedures/functions in the same package -
« Last Edit: May 20, 2010 by sippsin » Report to moderator   Logged

DTecH Admin Team
Buy Oracle Interview Preparations Kit from DTecH IT Education - 250 Oracle Interview Questions and Answers.
avinash
Scholar
**

Appreciate? +0/-0
Offline Offline

Posts: 13


Welcome!
« Reply #2 on: June 25, 2010 »
We can define private procedure in any package which can be called within that package only.
Report to moderator   Logged
Pages: [1] Go Up Send this topic Print 
« previous next »
 
Share this topic...
In a forum
(BBCode)
In a site/blog
(HTML)



Login with username, password and session length

Powered by MySQL Powered by PHP Powered by SMF 2.0 RC1.2 | SMF © 2006–2009, Simple Machines LLC Valid XHTML 1.0! Valid CSS!
Page created in 0.631 seconds with 18 queries.