Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 504
  • Last Modified:

Oracle sequence number ODBC problem

I'm trying to get the next sequence number from an Oracle sequence with:

SELECT WRV.WRV_SEQ_ADRESSEN.NEXTVAL FROM DUAL

This works fine with the Oracle ODBC drivers from Oracle, but not with those from microsoft. Miscrosoft gives an "value out of range" error (error 22003) for sequences with high numbers.

I checked the ODBC trace for both drivers and it appears that the Microsft versions see the NEXTVAL column as a SQL_C_SHORT (5 positions) where Oracle sees it as a SQL_C_DOUBLE (8 positions).

Unofrtunately the target machine has only Microsoft ODBC drivers so I'm stuck with those.

How do I tell the Microsoft ODBC driver for Oracle to use a larger datatayp for the NEXTVAL column?

How can I instruct
0
patrickl
Asked:
patrickl
  • 2
  • 2
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
You can cast the value to varchar datatype:

SELECT to_char(WRV.WRV_SEQ_ADRESSEN.NEXTVAL) FROM DUAL

CHeers
0
 
patricklAuthor Commented:
Cool, that works! I was trying something like that, but no luck. Great!

Do you have an idea why this goes wrong at all?
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
the ODBC drivers have different data type representations, and while the ORACLE driver knows the data types, the one of MS does some kind of approximation :-(
Glad I could help.
CHeers
0
 
patricklAuthor Commented:
I guess ODBC is just a minefield. I always keep running into trouble with it. The oracle drivers never seem to install and the Microsoft ones don't always work.

But anyway, many thanks.

Just to be complete. I change the query to:

SELECT to_char(WRV.WRV_SEQ_ADRESSEN.NEXTVAL) AS NEXTVAL FROM DUAL

To make it equivalent to the one I had before. Works like a charm.
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now