RDBPROD: Program Fails With a Wrong Transaction State if Hot Standby is Inactive
Last updated on JULY 05, 2017
Applies to:Oracle Rdb Server on OpenVMS - Version 7.1.2 and later
HP OpenVMS Alpha
HP OpenVMS Itanium
A program that runs against a standby database fails if replication is inactive, but works when replication is active.
The program uses a SET TRANSACTION READ ONLY RESERVING table-name FOR SHARED READ. The error returned by this SET TRANSACTION statement is:
If the application does not check the SQLCODE of the SET TRANSACTION statement it does not recognize that the SET TRANSACTION statement failed and any further program execution is unpredictable.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms