Mega Code Archive

 

Categories / Delphi / ADO Database

 

invalid row id when migrating from oracle 7 to oracle 8

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.