Problem with BreakExecution and Local Database

[kborsare]

I developed a mult-threaded application that lets the user break a query (by calling BreakExecution). It works fine when I connect to a remote server (on a different machine). It also works fine when I connect to a local server (same machine) if I go through TNSNames. However, if I connect to a local server, by specifying a blank TOracleSession.LogonDatabase, the call to BreakExecution does not work reliably. I've experienced access violations, and a variety of other errors after attempting to break execution with this type of connection.

I also experimented with the PLSQLDeveloper on the same workstation and experienced similar problems.

I can work around the problem by connecting to local servers through TNSNames and the Oracle Listener. I was just wondering if anyone has encountered this problem and figured out how to get it to work without going through TNSNames and the Listener?

Thanks,
-Ken

 

[Marco Kalter]

We have noticed in the past that not all Personal Oracle7 versions can handle a break. I'm not sure if this also applies to other Oracle7 Servers with local connections, we haven't tested this. What Oracle Server version are you using?

------------------
Marco Kalter
Allround Automations