Oracle SQL Forum
May I know that difference between Standalone Procedure and Stored Procedure?
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.
Sign up for STechies