Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004

    Unanswered: Delphi ODAC with threads


    I'm constructing an application that makes query's through threads in the data base oracle. But when I qualify several threads at the same time, the server returns the message: "ORA-01013 to user requested cancel of current operation."
    Somebody knows as to decide this?

    I'm using component ODAC to have access Oracle 8.

  2. #2
    Join Date
    Nov 2002
    Desk, slightly south of keyboard

    I don't use ODAC but it sounds like each thread is executing on the same Oracle connection, as a new thread executes a query, the previous threads query is being cancelled.

    You need to execute each thread on it's own connection (session in Oracle terms).

    Please don't email me directly with questions. I've probably just got home from the pub and cannot guarantee the sanity of my answers. In fact, I can't believe I actually made it home.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts