I have found that some Oracle datatypes are not directly supported by WinTask's ODBC functions.

For example you cannot use DbGetFieldNumeric() with Oracle Number fields. When you try, you will get an execution error that indicates the field is not a numeric field:

Error at line 13 : XXX is not a numeric field

WinTask Tech Support indicates that they don't support this type of numeric field.

Is anyone else using ODBC with Oracle? Any good tips?

Here are the workarounds I found that work for us: