Re: Could not reserve record (2 tries)...

"Mark C. Stock" <mcstockX_at_Xenquery .com> wrote in message news:x5WdncTr_ajdbu3eRVn-ow_at_comcast.com...
>
> "Pat" <Pat_at_microsoft.com> wrote in message
> news:dkqpkk$ci5$1_at_news.hgc.com.hk...
> > Hi All,
> >
> > While a row is being locked by another process, Oracle forms will pop
> > up "Could not reserve record (2 tries)" message. I tried to customize
> > this message by:
> >
> > In ON-LOCK trigger,
> > select the same row for update nowait;
> > if record being locked (oracle error code 54), display the customised
> > message.
> >
> > However, oracle forms displayed the customized message twice rather than
> > once!!
> >
> > Does anyone know the reason why? and how to bypass it?
> >
> > Thanks
> >
> >
>
> looks like it's doing what it original did, but just with your code (2
> tries)
>
> try the ON-MESSAGE or ON-ERROR trigger (i'm thinking ON-MESSAGE is the
one)
>
> ++ mcs
>
>

Tried both. Since there's no error/message returned, no way to capture this funny message! Received on Wed Nov 09 2005 - 14:26:06 CET