HELP - Numeric value out of range errors

From: Fuzzy <granta_at_nospam.student.canberra.edu.au>
Date: Mon, 30 Aug 1999 07:08:05 GMT
Message-ID: <37ca27de.28335053_at_newshost.interact.net.au>

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       

AutoCommit OFF

INSERT into TStmp12345 (uri) SELECT uri from PARENTTAB where URI IN
(169979975)

AllocStmt
ExecDirect
FreeStmt
AllocStmt

[Quoted] 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 - 09:08:05 CEST