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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Oracle Linked Server returns ORA-03113

Author  Topic 

cidmi.dovic
Yak Posting Veteran

53 Posts

Posted - 2010-03-04 : 06:46:52
Hi,

I have an oracle linked server and I have an issue that i cant understand.

The error is:
ORA-03113: end-of-file on communication channel

and the reason is due to the lenght of the query. I mean i am using the command openquery for executing querys in this oracle server, if the lenght of the query is smaller than 1024 characters it works if it is bigger I have the error above.

Any idea?
Thank you.

The Padrón peppers itch and other don't
   

- Advertisement -