RDBPROD: Transaction Reusable Services Do Not Allow Connections to More Than 1 Client with ORDP

(Doc ID 814894.1)

Last updated on MAY 03, 2017

Applies to:

Oracle SQL/Services for Rdb on OpenVMS - Version 7.1 and later
Oracle Rdb Server on OpenVMS - Version 7.1 and later
Oracle Rdb Developer Tools for Visual Studio - Version 7.3 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

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