PLS-00711: PRAGMA AUTONOMOUS_TRANSACTION cannot be declared
twice



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-26080: file "string" is not part of table string.string partition string

1 Answers  


ORA-27149: assignment out of range

1 Answers  


NZE-28753: failure to terminate use of data source

1 Answers  


IMP-00086: TOID "string" not found in export file

1 Answers  


ORA-14121: MODIFY DEFAULT ATTRIBUTES may not be combined with other operations

1 Answers  






ORA-31203: DBMS_LDAP: PL/SQL - Init Failed.

1 Answers  


ORA-30690: timeout occurred while registering a TCP/IP connection for data traffic detection

1 Answers  


ORA-01372: Insufficient processes for specified LogMiner operation

1 Answers  


ORA-00220: controlfile not mounted by first instance, check alert log for more info

1 Answers  


NNF-01003: DCE could not find cell name

1 Answers  


ORA-13345: a compound polygon geometry has fewer than five coordinates

1 Answers  


ORA-09884: Two Task interface: SID doens't match current PU

1 Answers  


Categories