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

nick048 wrote:
it is from SQL Server - try defining the grid block, based on
a procedure.

Something else strikes as odd: blocks based on views should
not be updateable (unless insetad-of triggers are used),
as views cannot be updated. You are sure you want your gird
updateable?
--
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

"Frank van Bortel" <frank.van.bortel (AT) gmail (DOT) com> schreef in bericht
news:fgfvcj$1ko$1 (AT) news5 (DOT) zwoll1.ov.home.nl...
If this is a single table view, you may have to include the rowid of the
underlying table (though I don' t know anything about SQL server, does it
have one?) I used Heterogenous Services with DB2 and we had to use a
rowid-like column in the select. In that case it HAD to be the first column.
But it's a loooong time ago, back in '96 or so....
@Frank: in Forms single table views can be updated, as long as one provides
a 'fake' primary key (being the prim key of the table).

Shakespeare

Shakespeare wrote:
OK - thanks for the update - must be a new feature since I last
used it.
Nevertheless - it's a view, ultimately coming from SS - I doubt
if that's ever going to work. My 2c are on procedures - TSQL
can probably do it.

--
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

"Frank van Bortel" <frank.van.bortel (AT) gmail (DOT) com> schreef in bericht
news:fgnp8a$ga6$1 (AT) news5 (DOT) zwoll1.ov.home.nl...
Frank,

Guess you're right about SqlSurfer. For an update over HS or Transparant
Gateways, a view may not work. A synonym for the table on the other side
might, but I don't think Forms will recognize it. Procedures will be the
right choice.

Shakepeare.