Example routines Oracle - PL / SQL

The seller is blocked and sales of the product are suspended

Example routines Oracle - PL / SQL: stored procedures, functions, packages, and triggers. The procedure is considered with all three prametrami: in, out, in out. The program has a detailed commentary. It is written with the aim to understand the difference between the function of the procedure. This program - just an example.