|
Home > Archive > Tools for Oracle database > November 2005 > Could not reserve record (2 tries)...
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Could not reserve record (2 tries)...
|
|
|
| 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
| |
| Mark C. Stock 2005-11-08, 3:57 pm |
|
"Pat" <Pat@microsoft.com> wrote in message
news:dkqpkk$ci5$1@ne
ws.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
| |
|
|
"Mark C. Stock" <mcstockX@Xenquery .com> wrote in message
news:x5WdncTr_ajdbu3
eRVn-ow@comcast.com...
>
> "Pat" <Pat@microsoft.com> wrote in message
> news:dkqpkk$ci5$1@ne
ws.hgc.com.hk...
>
> 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!
|
|
|
|
|