Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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 2 No

Post New Answer

More Oracle Errors Interview Questions

ORA-07844: sllfop: LIB$GET_VM failure

1 Answers  


ORA-31050: Access denied

1 Answers  


RMAN-08135: some corrupt blocks found during conversion of file string

1 Answers  


PCC-01016: "N" character literals not supported in embedded PL/SQL

1 Answers  


RMAN-06068: recovery aborted because of missing datafiles

1 Answers  






ORA-22062: invalid input string [string]

1 Answers  


QSM-02135: agg(expr) requires correspondng AVG(expr) function

1 Answers  


ORA-02056: 2PC: string: bad two-phase command number string from string

1 Answers  


RMAN-03023: executing command: string

1 Answers  


NZE-28795: data type attribute did not terminate

1 Answers  


PLS-00229: Attribute expression within SQL expression

1 Answers  


CLSR-00504: Error number encountered when posting an EVM event

1 Answers  






Categories