Timer Trick For Restricted Built-ins
"There Is No Two Drivers For One Car"
The reason for this restriction we can simply imagine.
The Question is ... does the car allow two car drivers at the same time?
The same logic applies to Oracle Forms.
In concurrence, these navigational triggers also fire in response to Oracle Forms internal navigation during its default processing.
What is a timer ?
- An automatic forms data refresh.
- An automatic forms commit.
- Animate forms interface e.g.
For such business requirements, at the moment the forms is pre-loading, the user needs the cursor focus to go to a specific block. Now, the forms rejects this navigation with the following error
Create a Timer:
- Declare a variable of timer data type.
- Initialize a variable with one second number data type.
- Use a CREATE_TIMER built-in with the timer's name, interval and it's status whether it repeats on expiration or non-repeated; execute once only in PRE-FORM trigger Form-Level.
- Assign the timer's creation to that variable of timer data type with the following code :
A Timer must has an end you specify to execute the restricted built-in sub-program within a specific trigger you create called When-Timer-Expired trigger Form-Level.
In other words, between the timer's creation and its expiration a pre-determined tiny interval you specify on timer's creation, within this interval you can execute the restricted built-in sub-program with the following code in When-Timer-Expired Trigger Form-Level :
The same logic used for any illegal restricted procedure. It all depends upon your business application logic for which you are using the timer