Home » Infrastructure » Windows » Problem with sequences (.NET, OleDB, Oracle 10G, Oracle 12C)
Problem with sequences [message #669548] Sat, 28 April 2018 04:10 Go to next message
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 #669549 is a reply to message #669548] Sat, 28 April 2018 09:20 Go to previous messageGo to next message
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Consider to open Service Request with MOS.
Re: Problem with sequences [message #669550 is a reply to message #669548] Sat, 28 April 2018 10:17 Go to previous message
John Watson
Messages: 8939
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
Previous Topic: Solution for the problem of oracle 10g installation on windows server 2008 R2 Datacenter SP1
Next Topic: Server Reboot not making DB ON.
Goto Forum:

Current Time: Sun Jul 21 21:40:33 CDT 2024