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-19805: recid string of string is about to be deleted or resized

1 Answers  


ORA-22880: invalid REF

1 Answers  


RMAN-05003: point-in-time recovery is not allowed for tablespace string

1 Answers  


KUP-02002: unexpected end of input file reached

1 Answers  


ORA-22971: invalid datatype for PRIMARY KEY-based object identifier

1 Answers  


ORA-13525: error with computing space usage for sysaux occupant

1 Answers  


ORA-38303: invalid option for PURGE TABLESPACE

1 Answers  


DRG-10516: failed to perform DDL operation due to an Oracle error

1 Answers  


ORA-16536: unknown object type

1 Answers  


ORA-22955: The cardinality parameter is not within the allowed limits

1 Answers  


ORA-07449: sc: usnewlock failed.

1 Answers  


RMAN-06536: BACKED UP ... TIMES option is supported only for archived logs

1 Answers  


Categories