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 |
---|---|
Performs SQL commands. |
|
Retrieves values from Oracle Forms to a foreign function. |
|
Sends values from a foreign function to Oracle Forms. |
|
Passes a message from a foreign function to display in Oracle Forms. |
|
Obtains context information previously saved in a foreign function. |
|
Saves context information from one foreign function for use in subsequent foreign function invocations. |
|
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.