Oracle Error: Cusor invalidated due to Parallel Execution

From: <rajneesharora80_at_gmail.com>
Date: 2 Mar 2006 05:06:19 -0800
Message-ID: <1141304779.025204.176640@v46g2000cwv.googlegroups.com>

HI,
I am running a query with 8 parallel threads. There is no DDl getting executed at that point in time. But still i am getting this error:

ORA-12842: Cursor invalidated during parallel execution 2006-03-02:02:06:30

I am not sure why this error is coming.
I am using Oracle 9i database with Linux operating system.

This error doesnt come everytime, sometinmes teh query goes through fine but many a time it fails with this error.

Can you help me finding teh error.

Thanks,
Raj Received on Thu Mar 02 2006 - 07:06:19 CST