Hello, I received a request from a developer, who is working on a client C++ front end application intended to perform semi-customized queries against a star schema in a datawarehouse. By semi- customized, I mean the fields selected are usually the same, the user can change date ranges, age ranges, etc., affecting the where clause. This app communicates with Oracle 8.1.7.4 server on Solaris via an oracle8 ODBC driver. The developer is looking for a way to allow the user to interrupt/kill any queries from the application. Here is an excerpt of his request: >> Apparently the Oracle8 ODBC drivers don't support asynchronous execution at all, so it can't be done through ODBC. After hunting through Oracle documentation, I've considered starting the query in one thread, and killing it in another with a command like ALTER SYSTEM KILL SESSION '[sid], [serial#]'.
A couple of questions: 1. How big a deal would it be to grant users the ALTER SYSTEM privilege, so <app_name> could kill their sessions? Would this have the desired effect of just abandoning the query? 2. Are you aware of any other, better ways to kill a query, given that ODBC doesn't directly support it? >> I am hesitant to grant alter system to users. Does anyone have a better suggestion? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
