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 |
|
srimyl
Starting Member
1 Post |
 Posted - 2015-04-06 : 08:10:17
|
| Hi, I've an issue while calling Oracle Stored procedure from MS SQL Server 2012 using LINKED SERVER, It gets connected and do the execution, But sometimes, it was disconnected and says this message 'A severe error occurred on the current command. The result if any should be discarded'. I'm not getting any clue on this issue. Do you come across anything like these kinda issue? Please share your ideas. Thanks in advance. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2015-04-06 : 12:23:19
|
| You'll need to investigate the network and the Oracle server. It is unlikely an issue on the SQL Server side.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2015-04-07 : 01:44:52
|
| The issue is either at the Oracle server or the client API. Most likely the former. Can you get a stack dump from the Oracle server?Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
Linked Server getting disconnected