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

EXEC SQL Statement

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.

Syntax

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.

EXEC SQL statement Restrictions

Using SQL commands in an Oracle Precompiler foreign function has the following restrictions: