Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Oracle sequence number ODBC problem

Posted on 2002-05-16
4
Medium Priority
?
501 Views
Last Modified: 2008-03-10
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
Comment
Question by:patrickl
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 800 total points
ID: 7013390
You can cast the value to varchar datatype:

SELECT to_char(WRV.WRV_SEQ_ADRESSEN.NEXTVAL) FROM DUAL

CHeers
0
 
LVL 5

Author Comment

by:patrickl
ID: 7013397
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
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 7013399
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
 
LVL 5

Author Comment

by:patrickl
ID: 7013413
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

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

610 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question