Procedure Call « Stored Procedure Function « Oracle PL / SQL

1.Call a stored procedure in a PL/SQL block
2.Call a stored procedure then other statements
3.Dependency Example
4.Forward Declarations
5.Exceptions in Subprograms
6.A PL/SQL procedure with no parameter
7.Exception throwed out of procedure call
8.Default parameter value
9.Pass parameter by data type

10.Calling ParameterLength illegally (ORA-6502)...
11.Use named notation
12.Use named notation, but with a different order of the formal parameters
13.This script demonstrates how to create and call a simple procedure.