RDBPROD: SQLMOD Procedure Returns Prior Call's Results

RDBPROD: SQLMOD Procedure Returns Prior Call's Results (Doc ID 65884.1)

Last updated on AUGUST 08, 2016

Applies to:

Oracle Rdb Server on OpenVMS - Version 7.0 and later
HP OpenVMS VAX
HP OpenVMS Alpha
HP OpenVMS Itanium

Symptoms

An SQL Module Procedure returns a prior call's results under the following circumstances:

It is not the first call to this procedure for this invocation of the image.
The problem parameter(s) are assigned values within conditional processing.
The parameter(s) not traced in the SQLMOD procedure do not change values.

The following command sequence will reproduce the problem, along with the source for the C program and SQL Module, and a sample run.

Command Sequence:

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

Applies to:

Symptoms

Cause

Sign In with your My Oracle Support account

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