RDBPROD: SQLMOD Procedure Returns Prior Call's Results
(Doc ID 65884.1)
Last updated on NOVEMBER 07, 2019
Applies to:Oracle Rdb Server on OpenVMS - Version 7.0 and later
HP OpenVMS Itanium
HP OpenVMS VAX
HP OpenVMS Alpha
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!