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

PLS-01900: : character to number conversion error

1 Answers  


ORA-07231: slemcc: invalid file handle, seals do not match.

1 Answers  


PCC-02429: Expecting an expression of some internal LOB type

1 Answers  


NZE-29227: Certificate is expired.

1 Answers  


NPL-00303: uninitialized ASN.1 class attribute

1 Answers  






ORA-16723: Setting AlternateLocation property conflicts with the log transport setting.

1 Answers  


ORA-21615: copy of an OTS (named or simple) instance failed

1 Answers  


ORA-36678: (XSDPART16) workspace object is missing from one or more partition dimension lists.

1 Answers  


ORA-02839: Sync of blocks to disk failed.

1 Answers  


ORA-27075: SSTMOFRC constant too large

1 Answers  


ORA-30005: missing or invalid WAIT interval

1 Answers  


NID-00139: Mismatched dbname for datafile string, expected string, found string

1 Answers  


Categories