Displaying 1 result from an estimated 1 matches for "sqlerrd".
2004 Nov 23
0
ROracle: fetch return zero rows or empty dataset (a workaround!)
...m annoyed by this problem for months. After searching and
waiting for months, I see no one seems to know what is wrong, so I
decided to trouble-shooting the problem myself. After a lot of
investigation and debugging, I found that the ROracle Pro*C module
does not get a proper return code in sqlca.sqlerrd[2]. Those who know
embedded SQL should know that this field gives the number of "rows
returned from the database". In fact, the return code is returned to
a wrong place: sqlca.sqlerrd[1]. This problem is a result of a
non-matching data definition of the data structure "sqlca"...