SQL & PL/SQL

Hi All,

My requirement is to do a parallel insert into a table. This is what I am doing inside the package body EMP_PKG.

EXECUTE IMMEDIATE 'alter session enable parallel dml';

INSERT /*+ PARALLEL (EMP,2,1) */
INTO EMP_DUMMY
SELECT * FROM EMP;

EXECUTE IMMEDIATE 'alter session enable parallel dml';

But this is throwing the following error:
ORA-12841: Cannot alter the session parallel DML state within a transaction

Am I missing some thing here? Please let me know

Thanks in advance :-)