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-30550: index depends on a package/function spec/body which is not valid

1 Answers  


ORA-32014: error processing parameter "string" from the SPFILE restore image

1 Answers  


ORA-29887: cannot support row movement if domain index defined on table

1 Answers  


ORA-02144: no option specified for ALTER CLUSTER

1 Answers  


ORA-17611: ksfd: file 'string' cannot be accessed, global open closed

1 Answers  






ORA-22166: collection is empty

1 Answers  


TNS-04086: Invalid value for the event string.

1 Answers  


ORA-07821: sspsdn: SYS$DELLNM failure

1 Answers  


ORA-24500: invalid UTF16 mode

1 Answers  


DRG-13000: error while adding or removing a sub lexer

1 Answers  


QSM-00781: the specified value string is invalid for parameter string. Valid keywords are string

1 Answers  


ORA-40001: value for string must be greater than zero

1 Answers  


Categories