My Oracle Support Banner

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

Last updated on APRIL 18, 2022

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

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.