Re: ON-COMMIT trigger (question)

In article: <1995Jun15.160110.14143_at_ericsson.se> "wei he (martletts)" <etlwihe> writes:
>
> Hi
> Can anybody confirm the following statement
>
> "If on-commit trigger fails, a rollback will take place."
>
> Thanks
>
> Wei
>
>
>

  The following is from the manual, it would appear that it doesn't do a rollback.

On-Commit Trigger

Fires whenever Oracle Forms would normally issue a database commit statement to finalize a transaction. By default, this operation occurs after all records that have been marked as updates, inserts, and deletes have been posted to the database.

Replaces: The default COMMIT statement that Oracle Forms issues to finalize a transaction during the Post and Commit Transactions process.

Definition Level: form

Legal Commands: SELECT statements, PL/SQL, unrestricted built-ins

Enter Query Mode: no

Usage Notes:

                Use an On-Commit trigger to change the conditions of normal Oracle Forms commit processing to fit the particular requirements of a commit to a non-ORACLE database.

                To perform the default processing from this trigger, call to the COMMIT_FORM built-in.

On Failure: Aborts Post and Commit processing

Fires In: Refer to the following process flowchart in the Oracle Forms Processing Manual:

Post and Commit Transactions

Example: This example disables the commit operation when running against a datasource that does not support transaction control. If the application is running against ORACLE, the commit operation behaves normally.

	BEGIN
	  IF Get_Application_Property(DATA_SOURCE) = 'ORACLE' THEN
	    Commit_Form;
	  END IF;
	  /*
	  ** Otherwise, no action is performed
	  */
	END;



----------------------------------------------------------------------------
	Come, let us retract the foreskin of ignorance, and apply the
	wirebrush of enlightenment

	Tim London			phone :	+44 1753 662393
	Oracle DBA,Trainer and		mobile:	+44 836 287064
	part time OU tutor		Email : tim_at_artemis.demon.co.uk
----------------------------------------------------------------------------