PLS-00711: PRAGMA AUTONOMOUS_TRANSACTION cannot be declared twice

PLS-00711: PRAGMA AUTONOMOUS_TRANSACTION cannot be declared
twice

Question Posted / guest

1 Answers
3021 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-31042: Too many properties in type 'string'

1 Answers

ORA-14634: Subpartition descriptions cannot be specified during the SPLIT/MERGE of a partition of a Range-List partitioned table

1 Answers

LSX-00132: attribute "~1S" has invalid occurrences value "~2S"

1 Answers

ORA-22626: Type Mismatch while constructing or accessing OCIAnyData

1 Answers

ORA-08003: sequence string.NEXTVAL exceeds internal limits

1 Answers

DRG-10841: invalid SCORE argument supplied to FUZZY

1 Answers

ORA-09809: Unable to get user's group ID from connection

1 Answers

ORA-14460: only one COMPRESS or NOCOMPRESS clause may be specified

1 Answers

ORA-23380: propagation mode "string" is not valid

1 Answers

AUD-00704: invalid input format

1 Answers

SQL*Loader-00904: You cannot used the direct path when linked with v5 of the database

1 Answers

ORA-39141: dump file "string" is a duplicate of dump file "string"

1 Answers

For more Oracle Errors Interview Questions Click Here