A script-enabled browser is required for this page to function properly.

Precompiler Statements

All Oracle Precompiler foreign functions can use host language statements to perform procedural operations. Precompiler foreign functions can also use the following types of statements to perform additional functions such as accessing the database and manipulating Oracle Forms variables and items.

Statement

Use

EXEC SQL

Performs SQL commands.

EXEC TOOLS GET

Retrieves values from Oracle Forms to a foreign function.

EXEC TOOLS SET

Sends values from a foreign function to Oracle Forms.

EXEC TOOLS MESSAGE

Passes a message from a foreign function to display in Oracle Forms.

EXEC TOOLS GET CONTEXT

Obtains context information previously saved in a foreign function.

EXEC TOOLS SET CONTEXT

Saves context information from one foreign function for use in subsequent foreign function invocations.

EXEC ORACLE

Executes Oracle Precompiler options.

An Oracle Precompiler foreign function source file includes host programming language statements and Oracle Precompiler statements with embedded SQL statements. Precompiling an Oracle Precompiler foreign function replaces the embedded SQL statements with equivalent host programming language statements. After precompiling, you have a source file that you can compile with a host language compiler. For more information on a specific precompiler, refer to the appropriate precompiler documentation for your environment.


Creating a PL/SQL interface to foreign functions