Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
raj vardhan43
Starting Member
20 Posts |
 Posted - 2012-11-01 : 16:53:47
|
| I have a linked server connection from SQL SERVER to Oracle.I am executing below command in Sql server management studio.select * from OPENQUERY(LINKEDSERVER,'select * from ORACLE_VIEW')I am getting an errorOLE DB provider "OraOLEDB.Oracle" for linked server "LINKEDSERVER" returned message "ORA-01858: a non-numeric character was found where a numeric was expected".Note: When i am executing "select * from ORACLE_VIEW" in oracle editor it is working fine.Please advise me on this!!Thanks for your time!!raj |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2012-11-02 : 05:26:24
|
| Find a row that is causing the problem - then find a column then find the character (if needed).Have a look at that in Oracle and you will probably find that it doesn't have a corresponding value in sql server and you can deal with it in the query.Could be that your linked server driver doesn't cope with that version of Oracle or the Oracle people have done something odd with a column or just that Oracle does something that sql servr can't cope with,It's common to get errors with things like dates because the two servers have different date ranges.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
SQL SERVER linked to oracle (error : non-numeric c