Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Usually there is a restriction on using <code>GO_BLOCK</code> or <code>GO_ITEM</code> on a <code>WHEN-VALIDATE-ITEM</code>. However there are a couple of ways to overcome this. One way is to use a <code>WHEN-TIMER-EXPIRED</code> trigger. Here is how-</p> <p><code>WHEN-TIMER-EXPIRED</code></p> <pre><code>Begin if GET_APPLICATION_PROPERTY(TIMER_NAME) = 'NEW_TIMER' then CALL_PROG_UNIT(); --This is your Procedure that calls the GO_BLOCK /*Do rest of validation here*/ end if; END; </code></pre> <p><code>WHEN-VALIDATE-ITEM</code></p> <pre><code>DECLARE timer_id TIMER; Begin timer_id := CREATE_TIMER('NEW_TIMER',1,NO_REPEAT); --set a short timer so that the WHEN-TIMER-EXPIRED trigger is fired immediately End; </code></pre> <p>What happens is - This will create &amp; expire the timer as soon as the <code>CREATE_TIMER</code> function is called and then the form level trigger <code>WHEN-TIMER-EXPIRED</code> will check the expired timer name and call your program unit that has the <code>GO_BLOCK</code>. Hope this helps.</p> <hr> <p><strong>UPDATE</strong></p> <p>Mr <a href="https://stackoverflow.com/users/103295/jeffrey-kemp">Jeffery Kemp</a> wanted to see proof that this solution works. So here it is-</p> <p>An Oracle form with two Blocks <code>BLOCK1</code> and <code>BLOCK2</code> with text items on it</p> <p><img src="https://i.stack.imgur.com/UGNu5.png" alt="enter image description here"></p> <p>W-V-I Trigger</p> <p><img src="https://i.stack.imgur.com/rJ8Bv.png" alt="enter image description here"></p> <p>W-T-E Form Trigger. This calls a PROGRAM UNIT <code>P_CALL_PROC</code> with <code>GO_BLOCK</code> function call first and then does some validations on the field <code>Number 2</code>.</p> <p><img src="https://i.stack.imgur.com/YyHhP.png" alt="enter image description here"></p> <p>Here is <code>P_CALL_PROC</code></p> <p><img src="https://i.stack.imgur.com/swVEO.png" alt="enter image description here"></p> <p>And here is the result-</p> <p><img src="https://i.stack.imgur.com/dsuli.png" alt="enter image description here"></p> <p>And</p> <p><img src="https://i.stack.imgur.com/6bs5F.png" alt="enter image description here"></p> <p><a href="http://www.youtube.com/watch?v=c8vcLCRp7EA" rel="nofollow noreferrer">Here</a> is a Youtube link to see the Form in action.</p>
    singulars
    1. This table or related slice is empty.
    1. POGO_BLOCK in WHEN_VALIDATE Trigger
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USAnnjawn
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POGO_BLOCK in WHEN_VALIDATE Trigger
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COOf course, this means that the procedure won't be executed until *after* the validation has been executed. Confused as to why the OP marked this as correct. Not that I have a better suggestion, mind you :)
      singulars
      1. PO
      1. USJeffrey Kemp
    2. COWell, you cannot call `go_block` or a `go_item` forms built in function from a `WHEN-VALIDATE-ITEM` item level trigger. This solution places the procedure which calls the `go_block` inside a Form level trigger and that form level trigger is invoked by the `TIMER` function at the item level trigger. Also, there could be additional validation or processing inside the procedure which will be executed when called, not sure if there is a problem there (i've used this in numerous forms and it works ;) Hence, The solution works that's why it was marked as correct.
      singulars
      1. PO
      1. USAnnjawn
    3. COPlease read my comment again. Just because it executes without error doesn't mean it solves the *problem as stated* - i.e. the desire to run some code BEFORE the validation has been executed. This is not a solution to the OP's *stated problem*. Whether his stated problem is his *actual* problem, of course, is another question entirely.
      singulars
      1. PO
      1. USJeffrey Kemp
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload