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