Difference between Standalone Procedure and Stored Procedure
Updated May 18, 2018
Hello,
May I know that difference between Standalone Procedure and Stored Procedure?
Standalone Procedure vs Stored Procedure
Comments
11 Aug 2015 11:44 am Abhijeet Mudgal Helpful Answer
The main types of program units you can create with PL/SQL and store in the database are standalone procedures and functions, and packages. Once stored in the database, these PL/SQL components, collectively known as stored procedures, can be used as building blocks for several different applications. Main advantage is : ORDBMS features on Stored procs/functions.
The main types of program units you can create with PL/SQL and store in the database are standalone procedures and functions, and packages. Once stored in the database, these PL/SQL components, collectively known as stored procedures, can be used as building blocks for several different applications. Main advantage is : ORDBMS features on Stored procs/functions.
Hope you understand now.