ORA-14462: cannot TRUNCATE temporary table in an autonomous transaction which is already in use by the parent transaction

ORA-14462: cannot TRUNCATE temporary table in an autonomous transaction which is already in use by the parent transaction


Cause:


An attempt was made to TRUNCATE a temporary table in an autonomous transaction which is already in use by the parent transaction.



Action:


Make sure the temporary table is not being used by the parent transaction before trying to TRUNCATE in an autonomous transaction.