My Oracle Support Banner

RDBPROD: Transaction Reusable Services Do Not Allow Connections to More Than 1 Client with ORDP (Doc ID 814894.1)

Last updated on OCTOBER 08, 2019

Applies to:

Oracle Rdb Server on OpenVMS - Version 7.1 and later
Oracle Rdb Developer Tools for Visual Studio - Version 7.3 and later
Oracle SQL/Services for Rdb on OpenVMS - Version 7.1 and later
Information in this document applies to any platform.
Oracle Data Provider for RDB (ORDP) (all versions)


Symptoms

Oracle Rdb Data Provider (ORDP) loses track of transaction state when used with Transaction Reusable services. Errors such as:

%SQL-F-NO_TXNOUT, No transaction outstanding

may be returned, along with additional unexplained locking in the Oracle Rdb database. Client applications may appear to hang as well, waiting for an executor.

Changes

Changed or configured SQL/Services services to be Transaction Reusable instead of Session Reusable. 

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
Changes
Cause
Solution

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