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 laterHP 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! |