I should have been more clear on this ..
Yes, it does work with worksheet or Sql* plus.
But not through ODBC for some reason.
If you use ODBC 32bit test, Oracle 8 and ODBC driver 8.00.57 or any other may be even 8.00.62.
It doesn't work.