Hi to All,
First, I use Oracle DB 10g and Forms Builder 10.
This is my "scenario":
1) I have create a Form with an header with the Text Items
CURRENT_YEAR, FROM_DATE, TO_DATE and a Button Item "Execute", and with
a Grid.
2) The button populate according with selections the grid with data
from an Oracle view that point to a remote non-oracle DB (SQL Server).
For the connection I have used Oracle heterogeneous services.
3) All work fine; the grid is correctly filled.
The problem is the editing of grid; if I try to modify a field in a
row of grid, this error is displayed:
FRM-40501: ORACLE error: unable to reserve record for update or delete
I have searched on the web, without appreciable result.
I need to edit the row, because I want create with each modified row a
new record in a different table of my Oracle DB.
Can someone help me ?
Best Regards.
Gaetano
|
