Retrieve numeric data from Oracle table
Posted on 2003-11-05
a simple question if you had experience this before. How to retrieve a numeric data from a table in Oracle's from SQL?
Actually, I want to insert a data into a table in SQL db but the data I pull from Oracle table. I manage to get the varchar2 and date column type data from Oracle, but when it comes to number, it give me this error message.
"Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error. The provider did not give any information about the error.
OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowset::GetNextRows returned 0x80004005: The provider did not give any information about the error.]."
This is a sample of my simple select statement that produce the above error:
select chartid from NEWEIS..EISADMIN.tbl_chart
****note : chartid is number(4)