When called from an On-Insert trigger, inserts the current record into the database during Post and Commit Transactions processing. This Built-in is included primarily for applications that will run against a non-ORACLE datasource.
PROCEDURE INSERT_RECORD;
Built-in Type restricted procedure
Enter Query Mode no
none
Valid only in an On-Insert trigger.
/*
** Built-in: INSERT_RECORD
** Example : Perform Oracle Forms standard insert processing
** based on a global flag setup at startup by the
** form, perhaps based on a parameter.
** Trigger: On-Insert
*/
BEGIN
/*
** Check the global flag we setup at form startup
*/
IF :Global.Using_Transactional_Triggers = 'TRUE' THEN
User_Exit('my_insrec block=EMP');
/*
** Otherwise, do the right thing.
*/
ELSE
Insert_Record;
END IF;
END;