PLS-00711: PRAGMA AUTONOMOUS_TRANSACTION cannot be declared twice

PLS-00711: PRAGMA AUTONOMOUS_TRANSACTION cannot be declared
twice

Question Posted / guest

1 Answers
2899 Views
I also Faced
E-Mail Answers

PLS-00711: PRAGMA AUTONOMOUS_TRANSACTION cannot be declared twice..

Answer / guest

Cause: The PRAGMA was declared twice in the same block.

Action: remove the duplicate declaration of the PRAGMA

Please add more information about this Error

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-31695: Inconsistent master table on restart. The following SQL statement returned string identical objects. string

1 Answers

ORA-02702: osnoraenv: error translating orapop image name

1 Answers

ORA-06953: Not enough virtual memory

1 Answers

ORA-36389: (XSAGPARTDEP01) Can not aggregate from PARTITION number into PARTITION number due to increasing sparsity along DIMENSION %J.

1 Answers

ORA-14315: cannot merge a partition with itself

1 Answers

ORA-12583: TNS:no reader

1 Answers

LPX-00246: missing system ID after public ID

1 Answers

TNS-12634: Memory allocation failed

1 Answers

ORA-12168: TNS:Unable to contact LDAP Directory Server

1 Answers

ORA-14071: invalid option for an index used to enforce a constraint

1 Answers

ORA-13225: specified index table name is too long for a spatial index

1 Answers

ORA-00105: too many dispatcher configurations

1 Answers

For more Oracle Errors Interview Questions Click Here