#5 win2000: db columns $tbl_name

[Anonymous]

The following command:

db columns $tbl_name

throws the exception:
22003 0 {[Oracle][ODBC]Numeric value out of range.}

I use win2000 SP2 (german), Oracle ODBC Driver
8.01.07.0 all other commands work well. Is there any
patch which fixes this problem?

[Paul Castelli]

Logged In: YES
user_id=269400

Got exactly the same error with Win2000 and Oracle 8.1.7

[Pat Thoyts]

Logged In: YES
user_id=202636

For what it is worth, using tcl8.4, tclodbc2.3.1 and MySQL
3.23 all under Windows 2000 the above command works fine.
You could check if this is a problem with the Oracle ODBC
driver by using something other than Tclodbc - say perl or VB.

I tried the columns on all my tables using
foreach tbl [db tables] { db columns [lindex $tbl 2] }
and they all worked (23 tables)

[Rolf Ade]

Logged In: YES
user_id=13222

Got the same error with tclodbc head on w2k, while trying
with oracle 8 and oracle 10i - but only, if I used the
oracle ODBC driver (out of the oracle 9.2 client). With the
MS ODBC driver for oracle, [db columns $tbl_name] just
worked as expected for both oracle 8 and oracle 10. So, from
my experiences, I'd suspect the oracle odbc driver to be the
culprit.

Though, I can't use the MS odbc driver for oracle for any
oracle table with a CLOB column - it returns error. (I can
access tables without any CLOB columns even with the MS odbc
driver for oracle). The oracle odbc driver doesn't has this
problem.