Description of the illustration call_stored_proc.gif

The figure illustrates how applications call a stored procedure in Oracle Database. The figure shows Oracle Database with a procedure, hire_emp(), stored in it. Three different applications are accessing the same stored procedure, hire_emp().