Board index » delphi » Oracle 8.04, BDE 5.01, Delphi 4: Invalid rowid error

Alain Mommaels

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Oracle 8.04, BDE 5.01, Delphi 4: Invalid rowid error

We have problem on using BDE 5.01 with an Oracle 8.04 server in an
application developed with Delphi 4. Sometimes, when we post a modification
in a row we receive an "Invalid rowid" exception with oracle message
ORA-01410. If we ask the details we receive the error number 13059 from the
BDE.
We have reproduced the same error when using the SQL explorer to modify row
directly.
The parameters of our alias BDE for ORACLE are:
type Oracle: 8.0.4.0.0
Batch count: 200
blob size: 200
blobs to cache: 64
enable BCD: true
enable integers: false
enable schema cache: false
langdriver:
list synonyms: none
max rows: -1
net protocol: TNS
object mode: true
open mode: read/write
rowset size: 20
schema cache dir:
schema cache size: 8
schema cache time: -1
server name: xxxxxx.world
sqlpassthru mode: shared autocommit
sqlqrymode:
username: yyyyy
If somebody can give us more info to solve this problem or to find more
info, it should be very nice.
 
Michael Glat

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Oracle 8.04, BDE 5.01, Delphi 4: Invalid rowid error


We were getting that error when we weren't using the correct DLL.  Make sure
in your BDE Administrator/Configuration tab that you are using the correct
DLL SQLORA8.DLL in the Drivers/Native/Oracle/DLL32 property.  The RowID
problem is common when you use Oracle 7 drivers to access the Oracle 8 DB.

--
Michael Glatz
mgl...@caiso.com

Quote
Alain Mommaels wrote in message <7dg7rr$...@forums.borland.com>...
>We have problem on using BDE 5.01 with an Oracle 8.04 server in an
>application developed with Delphi 4. Sometimes, when we post a modification
>in a row we receive an "Invalid rowid" exception with oracle message
>ORA-01410. If we ask the details we receive the error number 13059 from the
>BDE.
>We have reproduced the same error when using the SQL explorer to modify row
>directly.
>The parameters of our alias BDE for ORACLE are:
>type Oracle: 8.0.4.0.0
>Batch count: 200
>blob size: 200
>blobs to cache: 64
>enable BCD: true
>enable integers: false
>enable schema cache: false
>langdriver:
>list synonyms: none
>max rows: -1
>net protocol: TNS
>object mode: true
>open mode: read/write
>rowset size: 20
>schema cache dir:
>schema cache size: 8
>schema cache time: -1
>server name: xxxxxx.world
>sqlpassthru mode: shared autocommit
>sqlqrymode:
>username: yyyyy
>If somebody can give us more info to solve this problem or to find more
>info, it should be very nice.

Other Threads

1. Invalid Row ID - Ora 01410 - Delphi 4/BDE 5.01/Oracle 8.04

2. Invalid ROWID in Delphi 5 and Oracle 8.04

3. Delphi 3.0, Oracle 8.04: Invalid ROWID

4. Connect BDE 5.01 to a local server of Personal Oracle 8.04

5. Oracle 8.04, BDE 5.01 - Trouble reading TableNames

6. Oracle 8.04 and BDE 5.01 problem.

7. Delphi 3.0/BDE - Oracle 8 keeps on showing an error 'ORA-14110 Invalid ROWID

8. BDE 5.11 with ORACLE 8.04 - Translate errors : value out of bounds

9. Oracle8 + BDE 5.01 invalid page fault error

10. Oracle 8i ORA-01410 invalid ROWID error