Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> HELP - Numeric value out of range errors
I'm getting this error in one environment, but not in others. Same
code, same ODBC drivers, same versions of Oracle server and client,
all on NT. Are there any environmental config things that can affect
this?
here's what I'm trying (with nasty ODBC API stuff simplified)
AutoCommit ON
CREATE TABLE TStmp12345 (uri INT)
AllocStmt ExecDirect FreeStmt
INSERT into TStmp12345 (uri) SELECT uri from PARENTTAB where URI IN
(169979975)
AllocStmt
ExecDirect
FreeStmt
AllocStmt
SELECT /*+ ORDERED */ A0.uri FROM TStmp14593 A0, PARENTTAB A1 WHERE
( A0.uri = A1.uri ) AND ( A0.uri > 0 )
ExecDirect Fetch
This fetch throws:
ERROR state: 22003(0) Error: [Oracle][ODBC Oracle Driver]Numeric value out of range.
But only in one environment.
Any ideas?
Ciao
Fuzzy
:-)
Received on Mon Aug 30 1999 - 02:08:05 CDT