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.