From: "C:DEMONSPOOLMAIL" <tim@artemis.demon.co.uk>
Subject: Re: ON-COMMIT trigger (question)
Date: 1995/06/18
Message-ID: <192747939wnr@artemis.demon.co.uk>#1/1
sender: news@news.demon.co.uk
references: <1995Jun15.160110.14143@ericsson.se>
x-posting-host: artemis.demon.co.uk
organization: cairnport
reply-to: tim@artemis.demon.co.uk
newsgroups: comp.databases.oracle


In article: <1995Jun15.160110.14143@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@artemis.demon.co.uk
----------------------------------------------------------------------------