PLS-00710: PRAGMA AUTONOMOUS_TRANSACTION cannot be declared here



PLS-00710: PRAGMA AUTONOMOUS_TRANSACTION cannot be declared here..

Answer / guest

Cause: The PRAGMA was declared in an inappropriate context.
This PRAGMA has to be declared in the declarative section of
a procedure, a function, a top level anonymous block.

Action: Remove or relocate the misplaced pragma.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More Oracle Errors Interview Questions

ORA-31698: Error stack buffer size must be specified and must be greater than 0.

1 Answers  


RMAN-00571: ===========================================================

1 Answers   HCL,


ORA-08331: Wait operation timed out

1 Answers  


ORA-25958: join index where clause predicate may only contain column references

1 Answers  


ORA-13372: failure in modifying metadata for a table with spatial index

1 Answers  






ORA-02280: duplicate or conflicting CYCLE/NOCYCLE specifications

1 Answers  


LCD-00218: error in file [string]

1 Answers  


PLS-00620: type mismatch found at 'string' among operands in a COALESCE expression

1 Answers  


RMAN-10038: database session for channel string terminated unexpectedly

1 Answers  


PLS-00246: PARAMETER STYLE is unsupported

1 Answers  


ORA-24803: illegal parameter value in lob read function

1 Answers  


ORA-28537: no more result sets

1 Answers  


Categories