?
Solved

Oracle error ORA-01410 - invalid_rowid when editing record twice in same session

Posted on 2001-07-11
2
Medium Priority
?
573 Views
Last Modified: 2007-11-27
I have a delphi 3 application that is the GUI for an application that connects to an Oracle database. We connect to the database using Borland BDE.
When we upgraded from Oracle 7 to Oracle 8 (currently using 8.1.7) I noticed the following situation.
If I open a screen in the application that allows me to edit database records, then I can make the first edit (of any number of fields) for a particular record sucessfully. However, if I try to make more changes to that same record(after commiting the first ones) then I get Oracle error 01410 "Invalid ROWID". I have to close the screen and re-open it to make further changes. Re-querying the data with the screen still open still causes the same error.
We never had this issue when using Oracle 7.
I am currently using BDE 5.1.1.
0
Comment
Question by:fgraham
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 6

Expert Comment

by:zebada
ID: 6274668
Internally, the format, size and structure of the ROWID changed between ORA7 and ORA8. I don't have access to the ora docs so I can't be specific on what the changes are.



0
 
LVL 27

Accepted Solution

by:
kretzschmar earned 300 total points
ID: 6275811
from borland:

"Invalid Row ID" when migrating from Oracle 7 to Oracle 8 - by Borland Developer Support Staff



 Question and Answer Database

     FAQ: FAQ4662D - "Invalid Row ID" when migrating from Oracle 7 to Oracle 8
Category: Database(Oracle8)
Platform: All-32Bit
 Product: All32Bit,  

Question:

I just upgraded from Oracle 7 to Oracle 8 and now I
occasionally get an "Invalid Row Id" error. I am using
the new Oracle 8 Row Id's. How can I fix this error?


Answer:

This error may occur when posting to tables that contain
LONG/Blob fields. More than likely, you are using the
old SQL Link driver. Insure that you have the BDE 5.01 installed.
In the BDE Administrator go to the Configuration tab and select
Drivers->Native->Oracle. Make sure that the DLL32 is set to
SQLORA8.DLL and the VENDOR INIT is set to OCI.DLL. Another
possible solution may be to set the TTable or TQuery's
UpdateMode property to upWhereKeyOnly.


6/21/99 1:58:59 PM
 
meikl ;-)
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question