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

Last updated on APRIL 14, 2022

Applies to:

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

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

	To view full details, 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 a vibrant support community of peers and Oracle experts.

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

Applies to:

Symptoms

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!