Re: URGENT!!! FRM-40654

Hi Marc,

problem with your on-error trigger is that it only allows unrestricted built in while for example go_block is a restricted one. So you need to use a workaround. Try setting a variable in your on_error trigger which then signals what has happened to the when-new-block-instance trigger on the block you are interested in. There you can do a requery. What I am not 100% sure about is that the when-new-block-instance-trigger will fire, but you can easily test that.

Hope that helps a little bit

Conny
"marc" <nekoliko_1_at_yahoo.com> wrote in message news:beromn$2dd$1_at_sunce.iskon.hr...
> Hi,
> i need solution for that message in oracle forms, but through trapping in
> ON-ERROR trigger. How can we in on-error trigger make that program goes on
> some block and make execute_query ?
> Please, asnwer if you tried your solution...Example code is welcome...
> thx
> marc
>
>
Received on Tue Jul 15 2003 - 13:29:05 CEST