Cancel command with linked server

From: Pavel Savara <pavel.savara_at_gmail.com>
Date: Fri, 21 Dec 2007 04:13:31 -0800 (PST)
Message-ID: <bca12cee-eb35-48ea-b10f-6a766dcbbe29@1g2000hsl.googlegroups.com>

Hello,

I need to be able to cancel command. I found and tested that it works for ODP.NET client from 10.1.0.3. That's great. But in my command is call to stored procedure which is querying linked server, which is big and slow.

In such case, the command will continue running (probably till end of processing on linked server).
Same behavior could be seen when I set command timeout instead calling Cancel on the client.

What could be made to somehow propagate cancel command to linked server ?
Are there some switches which we should set on the servers, link, session or command ?
Could you please provide me with link to related documentation ?

Primary server is : Oracle9i Enterprise 9.2.0.8.0 Slow linked server is : Oracle10g Enterprise 10.2.0.3.0, 64bit

Thanks a lot
Pavel Received on Fri Dec 21 2007 - 06:13:31 CST