Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > Sequence.nextval numeric type in Oracle 10g differs from Oracle 8i when using MS OleDb provider

Thread Tools

Sequence.nextval numeric type in Oracle 10g differs from Oracle 8i when using MS OleDb provider
Posts: n/a
A bug I noticed which doesn't seem to be posted on usenet, nor
recognized by Oracle (who didn't want to help unless we had been using
their ADO.NET provider...):

We used to retrieve the sequence id, mysequence.nextval, into ADO.NET.
This was returned as a decimal and so we cast it directly to a
decimal. However, when we upgraded the Oracle database to 10g, the
code broke because the value thus returned was then a double
(which .NET can't seem to cast to a decimal - go figure). We were
using Microsoft's generic OleDb provider to access the Oracle
databases (Provider=MSDAORA.1).

The fix, it turns out, is to use the Oracle OleDb provider (Provider =
OraOLEDB.Oracle). This provides a drop-in replacement for the
Microsoft OleDb provider, and thus obviates the need for making
changes to the code (which for us would have been a pain). Hopefully
there are no significant differences otherwise between the two

I hope this helps someone else who may also come across this problem.

Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: Saving Rich Text Format (RTF) in Oracle 10g using PL/SQL via VB/ASP.NET Bill McCarthy ASP .Net 3 01-23-2009 09:37 AM
Arithmetic overflow error converting numeric to data type numeric. darrel ASP .Net 4 07-19-2007 09:57 PM
Hosting Provider for ASP.NET 2 and Oracle 10g? rdlauer ASP .Net 0 03-29-2007 04:22 PM
Access Oracle 10g using ASP.NET sloan ASP .Net 1 03-11-2006 06:48 AM
install_driver(Oracle) failed: Can't load 'C:/Perl/site/lib/auto/DBD/Oracle/Oracle.dll' for module DBD::Oracle: load_file:The specified procedure could not be found at C:/Perl/lib/ line 230. Feyruz Perl Misc 4 10-14-2005 06:47 PM