Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Forms 4.5, Blocks & Triggers (Help)

Re: Forms 4.5, Blocks & Triggers (Help)

From: <smagdaddy_at_aol.com>
Date: 1996/12/20
Message-ID: <19961220025900.VAA27263@ladder01.news.aol.com>#1/1

 I'm not sure what you mean by

>I am writting some Oracle Forms 4.5 programs and was wondering if there
 is an
>easy way of passing parameters to blocks. For example if I am in Block A
 and
>want to call Block B passing a parameter to it at the same time (I know
 this
>can be done using globals or :Block_A.Item_I_Want_To_Pass

but for the second part of your post,

>Another question I have is that can I cause a trigger in Block B to fire
 up
>when I am in Block A.

The way to do this is to move the code in the Block B trigger you want to fire, into a program unit. Then you can call the procedure or function from anywhere in the application.

Hope this helps.

P.S. This message really belongs under comp.databases.oracle.tools

Rodger Hollingsworth



US Navy (DBA, Dev2K, SCO Unix)
You'll never get it unless you ask, Then again you may not even if you do ask. Received on Fri Dec 20 1996 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US