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.
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. |
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.
It is not possible to get or set values directly into a record group from a foreign function.
/*
** 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;