Execution of PL/SQL Subprograms

 Users can execute a subprogram interactively in multiple ways.

oracle linux administration training courses malaysia

The options are:

• Using an Oracle tool, such as SQL*Plus or SQL Developer

• Calling it explicitly in the code of a database application, such as an Oracle Forms or precompiler application

• Calling it explicitly in the code of another procedure or trigger

The following graphic shows different database applications calling hire_employees.

oracle e business suite training courses malaysia

Figure 8-1 Multiple Executions of a Stored Procedure

Description of "Figure 8-1 Multiple Executions of a Stored Procedure"

Alternatively, a privileged user can use Oracle Enterprise Manager or SQL*Plus to run the hire_employees procedure using a statement such as the following:

oracle database training courses malaysia

EXECUTE hire_employees ('TSMITH', 'CLERK', 1037, SYSDATE, 500, NULL, 20); 

The preceding statement inserts a new record for TSMITH in the employees table.

A stored procedure depends on the objects referenced in its body. The database automatically tracks and manages these dependencies. For example, if you alter the definition of the employees table referenced by the hire_employees procedure in a manner that would affect this procedure, then the procedure must be recompiled to validate that it still works as designed. Usually, the database automatically administers such dependency management.

oracle cloud infrastructure training courses malaysia