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

EXEC TOOLS GET Statement

An EXEC TOOLS GET statement retrieves a value from Oracle Forms into an Oracle Precompiler foreign function. Specifically, it places the value of a Oracle Forms item or variable into a host language variable. Once the foreign function retrieves a value from Oracle Forms, the foreign function can use that value for calculation, manipulation, or updating.

Syntax

EXEC TOOLS GET form_variable_1[, form_variable_2, ...]
INTO :host_variable_1[, :host_variable_2, ...];

where:

form_variable_n

Specifies the name of the Oracle Forms item or variable from which you are reading a value.

host_variable_n

Specifies the name of the host language variable into which you are reading a value.

Notes:

The form_variable can be a reference to any of the following items:

Refer to the Programmer's Guide to the Oracle Precompilers for any restrictions on host language variables.

EXEC TOOLS GET statement Restrictions

It is not possible to get or set values directly into a record group from a foreign function.

EXEC TOOLS GET statement Examples

/*
** Example: Read an item name from a block (empblock.empname)
*/
EXEC SQL BEGIN DECLARE SECTION;
char itm_buff[255]; /* buffer for item value */
VARCHAR itm_name[255]; /* Forms item name */
EXEC SQL END DECLARE SECTION;
strcpy(itm_name.arr,"EMBLOCK.EMPNAME");
itm_name.len=strlen("EMBLOCK.EMPNAME");
EXEC TOOLS GET :itm_name
INTO :itm_buff;