How to call trigger stored in database using Oracle Forms

5 pts.
Tags:
Oracle development
Oracle Forms
Oracle triggers
Triggers
how to call trigger stored in database using oracle forms

Answer Wiki

Thanks. We'll let you know when a new response is added.

You can’t call database triggers directly. You should use a stored procedure instead.

You can call stored procedures the same way you do for Forms local procedures.

Please provide more information if you need further help.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • 240210
    From trigger example: Execute_Trigger(‘When-New-Form-Instance’); It can also use for the Refresh button on the oracle form.
    230 pointsBadges:
    report
  • dinuas400
    we cannot call triggers directly, when we perform the ADD/update/delete on a specific table the triggers will be automatically triggered. If trigger exists...
    510 pointsBadges:
    report
  • Brijesh
    Hi,

    Check the below resource which guides you with triggers Database Triggers

    Hope this helps.
    9,870 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following