Error reading single character column (9i on Windows)

Hi all,
we are having a weird problem when retrieving a single column result set.
Both client and server are running 9i
Originally we faced it testing an VC++ OCI application, later reproduced in a simple VB project:

    Dim sQuery As String
    Dim rs As ADODB.Recordset     

    Set rs = New ADODB.Recordset
    sQuery = "SELECT /*+FIRST_ROWS*/ COL1 FROM MYSCHEMA.MYTABLE"     rs.MaxRecords = 250
    rs.Open sQuery, m_cn, adOpenForwardOnly, adLockReadOnly     

    While (Not rs.EOF)

        Debug.Print rs("COL1")
        rs.MoveNext

after retrieving some 20-40 rows correctly, the rest is garbage, mostly question marks

The workaround seems to be very simple, just adding a second column to the select list fixes it

Has anybody experienced that before? How did you handle it? Received on Thu Feb 20 2003 - 22:01:47 CET