PLS-00711: PRAGMA AUTONOMOUS_TRANSACTION cannot be declared twice

PLS-00711: PRAGMA AUTONOMOUS_TRANSACTION cannot be declared
twice

Question Posted / guest

1 Answers
2817 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

TNS-01168: Cannot allocate memory

1 Answers

ORA-01593: rollback segment optimal size (string blks) is smaller than the computed initial size (string blks)

1 Answers

NZE-29003: SSL transport detected mismatched server certificate.

1 Answers

RMAN-05012: trying to start the Oracle instance without parameter files ...

1 Answers

NNO-00118: line string: data length string exceeds maximum of string, data ignored

1 Answers

ORA-12654: Authentication conversion failed

1 Answers

ORA-23399: generation of replication support for "string"."string" is not complete

1 Answers

DRG-10827: open_con must be performed before count_last

1 Answers

RMAN-06427: recovery catalog already exists

1 Answers

NNC-00403: program interface has not been initialised

1 Answers

TNS-12204: TNS:received data refused from an application

1 Answers

TNS-01065: Raw mode is string

1 Answers

For more Oracle Errors Interview Questions Click Here