DevOps, CI/CD and Automation

I'm new to Oracle and the Oracle OLE DB, but I've been programming in ASP and ADO for quite a while. It seems that whenever I retrieve a recordset from Oracle and use a field, I get a "type mismatch" error. For Example: I have a table that contains a numeric field "Cols". After I have opened the connection and recordset (named ObjRS) this line give me the type mismatch failure:

For i = 1 to ObjRS("Cols")

If I change the line to this:

for i = 1 to CInt(ObjRS("Cols"))

it works perfectly. Converting types in my code would be a HUGE inconvenience, so I must be doing something very simple wrong. Any suggestions?