RDBPROD: Program Fails With a Wrong Transaction State if Hot Standby is Inactive (Doc ID 1501322.1)

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

Symptoms

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.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms