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

    Unanswered: Delphi ODAC with threads

    Hello,

    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
    Location
    Desk, slightly south of keyboard
    Posts
    697
    Hi,

    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).

    Hth
    Bill
    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
  •