RDBPROD: Third Element of the SQLERRD Array is Not Updated (Doc ID 94357.1)

Last updated on AUGUST 08, 2016

Applies to:

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

Symptoms

The third element of the SQLERRD array is not updated when you PREPARE a statement and only pass the SQLCODE. This is true even though you pass the entire SQLCA structure at EXECUTE time.

Example:

The following sample program works as expected against the sample MF_PERSONNEL database unless the SQLCODE only is passed and received on the PREPARE call. In this case the program prints "Number of records: 0" instead of "Number of records: 100".

Header file (SAMPLE_SQLMOD.H):

 

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