ORA-12841: Cannot alter the session parallel DML state within a transaction
598338Sep 25 2007 — edited Aug 10 2010Hello,
We are executing the below statement in a procedure.
EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL DML';
This is the 1st statement in the procedure. This code was working since past many months, but yesterday it gave following error:
ORA-12841: Cannot alter the session parallel DML state within a transaction
My question is:
- What could make the statement to give this error ? (the code has not changed)
- Can this happen upon changing any db parameter ?
Please help, thanks in advance :)