RDBPROD: SQLMOD Procedure Returns Prior Call's Results
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
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms