FRM-40501 then ORA-24374 [message #500921] |
Thu, 24 March 2011 08:56 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
|
Hello,
I searched for ways to avoid these errors below but could not find yet anything which would help:
FRM-40501: ORACLE error: unable to reserve record for update or delete.
ORA-24374: define not done before fetch or execute and fetch
My master-detail form has single canvas. For both blocks, master and detail, two tables joined together in each. One table to be updated, second table has some info for reference (query only).
I am getting these errors when in detail block the item from LOV is selected for existing record. This does not happen for new record inserted in detail block.
Thank you.
|
|
|
Re: FRM-40501 then ORA-24374 [message #512369 is a reply to message #500921] |
Sun, 19 June 2011 16:32 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
I hope you already fixed it; however, if not, what does "two tables joined together in each" mean? Did you create a VIEW? If so, *maybe* an article ID 251589.1 on My Oracle Support addresses your problem (suggesting that you should add a dummy column to both a view, its underlying table, as well as a form).
Also, a problem might be in a fact that you are (if you are) using a LONG datatype form item (based on a CLOB datatype table column). However, your Forms version should have that bug fixed.
|
|
|