sqlfetchrows - data loss

[elvo]

Beware of this demon-posessed sc.ini parameter!


When this parameter is switched on, terrible things happen. Data is not displayed, and sometimes lost.

STR:
- OOB system with the numbers file mapped out to ORACLE
- sqlfetchrows:500
- database manager - true query on numbers file
- modify columns - add prefix and length to the QBE list
- take the last record ('knownerror'), remove its prefix and length
- return to the QBE

All of a sudden, all the prefixes and lengths are gone.

We've also seen cases where not all records are being fetched into the QBE. Either way, data is lost.

We've done a SQL*Net trace, it seems the data is fetched from Oracle OK, but SC loses its marbles looping through the OCI record buffer.

As a workaround, you can switch off sqlfetchrows. The data will be good, but SC will do at least one SQL*Net round trip per record fetched. For us, this implies a major performance issue.


http://forums11.itrc.hp.com/service/...readId=1047842