Invalid Data for type "numeric"

Question

Invalid Data for type "numeric"

Viewing 4 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Paul Bukowski Mr or Mrs. 500 Points: 565 More actions · Answer 1

Apparently this was a bug in the Oracle driver. The solution is to install an updated driver. Here are the details in case anyone else has same issue:

http://forums.oracle.com/forums/thread.jspa?threadID=337842&start=15&tstart=-2

Thanks,

Paul

PaulB-TheOneAndOnly SSC Guru Points: 66772 More actions · Answer 2

Since there is no NUMERIC data type in Oracle - closest one would be NUMBER I think driver was attempting some kind of data conversion from default datatype and failed.

Probably new version of the driver is smarter and got it done.

_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

chandan_jha18 SSChampion Points: 11330 More actions · Answer 3

http://www.microsoft.com/downloads/details.aspx?FamilyId=D9CB21FE-32E9-4D34-A381-6F9231D84F1E&displaylang=en#filelist

Try if you find something.I always swap between the two drivers (MSDAORA and ORAOledb)and one of them always helped me in many cases:-)

sreddyv26 Ten Centuries Points: 1038 More actions · Answer 4

Helo paul

In your query try with to_number(NumCol)

example

exec('select to_number(empno),ename from emp') at oralinksrv

Regards

Reddy