Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

BEFORE-COMMIT trigger

InoLApr 16 2015 — edited Jan 11 2016

Some business rules can only be validated at commit time. An example would be: a new department needs one manager and at least one other employee. This involves 3 inserts: one department, one manager and one employee. The rule fails on any of these individual inserts, but not on the commit, when these three inserts have taken place. So, you can only validate this rule in some sort of BEFORE-COMMIT trigger.

Oracle Forms has a nice trigger for this kind of functionality (Post-Forms-Commit):

Fires once during the Post and Commit Transactions process.  If there are records in the form that have been marked as inserts, updates, or deletes, the Post-Forms-Commit trigger fires after these changes have been written to the database but before Form Builder issues the database Commit to finalize the transaction.

(and I believe ADF 12c now also has a before commit trigger).

It would be great to have this kind of functionality on database level.

Comments

Jens Petersen
You need a valid licence, but then there are not additional charges to download from edelivery


Notice

By accessing the software on this Web site, you agree that (1) you have already obtained a license from Oracle, or an Oracle partner, for your use of the software and that your Oracle License and Services Agreement or Software License and Services Agreement, Oracle PartnerNetwork Agreement, Oracle distribution agreement, or other license agreement with Oracle or an Oracle partner, plus the applicable ordering document with Oracle or an Oracle partner, governs your use of the software, or (2) if you have not already obtained a license from Oracle or an Oracle Partner for your use of the software, the Oracle Electronic Delivery Trial License Agreement on this Web site governs your use of the software for the time specified in such agreement. Note: Programs downloaded for trial use or downloaded as replacement media may not be used to update any unsupported programs.



http://edelivery.oracle.com/EPD/GetUserInfo/get_form
oradba
You don't need a license, when you want to download Enterprise Linux from Oracle. Other products need a valid license.

Werner
SID3
Thanks for the reply. But how do i get the license. Can i get it by just filling up the get form( the link thats presented in previious thread).

Any help?
SID3
How to obtain license from Oracle Corporation for unlimited use of products at Oracle edelivery.
Nicolas Gasparotto
How to obtain license from Oracle Corporation for unlimited use of products at Oracle edelivery.
Did you want a licence for all the Oracle products ? What for ? Do you know how many are ?

Nicolas.
oradba
Edelivery.com is a download portal for those already having a valid license. You can buy Oracle software (including licenses) in the Oracle OnlineShop:
http://oraclestore.oracle.com

Under which circumstances you are allowed to use Oracle software without a license is clearly defined under 'license conditions' on the OTN download site.

Werner
1 - 6

Post Details

Added on Apr 16 2015
#active, #database-ideas, #database-ideas-ideas
12 comments
5,046 views