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-33215: (CINSERT07) You cannot add session-only values to the workspace object dimension.

1 Answers  


KUP-04073: record ignored because all referenced fields are null for a record

1 Answers  


ORA-13202: failed to create or insert into the SDO_INDEX_METADATA table

1 Answers  


PLS-01907: : number precision too large

1 Answers  


NZE-28772: invalid file ID

1 Answers  






NID-00300: Connected to database string (DBID=number)

1 Answers  


UDE-00007: attempt to free unallocated memory

1 Answers  


NNL-00853: Renames refused, new name already exists: number

1 Answers  


NID-00407: Reversion of database ID failed.

1 Answers  


ORA-23532: tables with different synchronization mechanisms are in the same group

1 Answers  


ORA-33060: (XSAGDNGL29) In AGGMAP workspace object, the value for the ERRORLOG MAX option must be greater than 0.

1 Answers  


ORA-32401: materialized view log on "string"."string" does not have new values

1 Answers  


Categories