| Problem with sequences [message #669548] |
Sat, 28 April 2018 04:10  |
 |
jclorente
Messages: 1
Registered: April 2018
|
Junior Member |
|
|
Hi all.
Recently, we have migrated from a 10G to a 12G server in a pre-production environment. In early tests, we have detected an strange InvalidCast error in a method that generates an autoincrement value from a sequence.
Debugging against the two environments, we have discovered that the returned type in OleDBCommand that gets NEXTVAL in Sequence is DBTYPE_R8 in 10G while DBTYPE_VARNUMERIC in 12C.
Is there any way to force the returned datatype in oledb access to NEXTVAL pseudocolumn?
Thank you in advance
|
|
|
|
|
|
| Re: Problem with sequences [message #669550 is a reply to message #669548] |
Sat, 28 April 2018 10:17  |
John Watson
Messages: 8962
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
You didn't mention it, but Googling those data types tells me that you are reading this data with a Microsoft OLE application. Is that right?
To the best of my knowledge, the data type returned by NEXTVAL has not changed between 10.x and 12.x, so perhaps the problem is with your client software, not on the Oracle side. You must be using (certainly should be using) a new version of the client, what is it?
And, just to do the moderator bit:
Welcome to the forum. Please read the OraFAQ Forum Guide and How to use code tags and make your code easier to read
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
