My Oracle Support Banner

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

Last updated on OCTOBER 02, 2019

Applies to:

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


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.


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):



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.