PL/SQL Architecture


PL/SQL is a technology and an integrated part of Oracle. it has its own processing engine that executes PL/SQL blocks and subprograms. This engine can be installed server or in any of the development tools such as Oracle Forms. If the host program does not have a PIJSQL engine‘ the blocks of code are sent to the Oracle server for processing.

Figure 4.3 shows the PL/SQL engine as an integrated component of the Oracle server. The engine executes procedure statements and passes SQL statements to the SQL statement executor in the Oracle server.

When Oracle tools come with a PL/SQL engine, the tools process the PL/SQL blocks directly.