Post reply

Cursor invalidated during parallel execution

  • March 30, 2009 at 4:30 am

    #130154

    Hi,

    My DTS have 5 parallel transfer data from sql db to oracle db at the same time, it have come up with an error "ORA-12842: Cursor invalidated during parallel execution"

    Based on the information I get is as per below:

    Cause: The cursor was invalidated during the parse phase of deferred parallel processing, e.g. when set operands are parallelized.

    Action: Depends on why the cursor was invalidated. Possible causes include DDL on a schema object and shared pool being flushed.

    I have no idea why it related to cursor. Can someone guide?

  • March 31, 2009 at 9:28 pm

    #969593

    Are it related to the sp not using the bind variable?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply