An EXEC SQL statement is a SQL command prefixed with "EXEC SQL." EXEC SQL statements allow you to perform any SQL command in an Oracle Precompiler foreign function. Use EXEC SQL statements to select or manipulate data in the database from a foreign function.
EXEC SQL sql_statement;
where sql_statement is any valid Oracle SQL statement, except for the restricted commands noted in this section.
You need to perform an explicit CONNECT in an Oracle Precompiler foreign function because Oracle Forms does not establish the connection automatically, except on UNIX. The Oracle Server does support concurrent connects. For more information, refer to the Programmer's Guide to the Oracle Precompilers.
Using SQL commands in an Oracle Precompiler foreign function has the following restrictions: