Skip to Main Content

Oracle Forms

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!

Disabling triggers on forms

696284Nov 6 2009 — edited Nov 19 2009
How do i disable a database trigger on forms developer 6.0? I have created a database trigger that prohibits editing of records after 15 days have elapsed since encoding the record. However, there are times when i allow editing of specific records based on valid reasons. I will try to disable the trigger temporarily on my pre-commit trigger in forms, grant update on specific columns of specific records and then enable the trigger again on post-commit. However, this does not work. Whenever I try to edit an old record, the trigger still fires. how do i solve this?

I have this code on my prre-commit:

FORMS_DDL('DISABLE SPM_IS.SPM_DAILY_OUTS_IRR_NEW ON SPM_IS.SPM_DAILY_OUTS');
FORMS_DDL('REVOKE UPDATE ON SPM_DAILY_OUTS TO SPMIS_ACC_USER');
FORMS_DDL('GRANT UPDATE (OUTAGE_TYPE, OUTAGE_CODE, OUTAGE_SUBCODE, REMARKS) ON SPM_DAILY_OUTS TO V_USER WHERE SEQ_ID = V_SEQ_ID');

Then on my post-forms-commit and post-database-commit, I have this code:

FORMS_DDL('ENABLE SPM_IS.spm_DAILY_OUTS_IRR_new ON SPM_IS.SPM_DAILY_OUTS');
FORMS_DDL('GRANT INSERT, SELECT, DELETE, UPDATE ON SPM_DAILY_OUTS TO SPMIS_ACC_USER');

Please help. Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 17 2009
Added on Nov 6 2009
2 comments
1,958 views