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


PCC-00139: Cannot change MAXLITERAL after an EXEC SQL statement



PCC-00139: Cannot change MAXLITERAL after an EXEC SQL statement..

Answer / guest

Cause: The MAXLITERAL option has been used in an inline EXEC
ORACLE OPTION statement after and EXEC SQL, EXEC TOOLS, or
EXEC IAF statement. This is not allowed.

Action: Use the MAXLITERAL option only on the command line
or in an EXEC ORACLE OPTION statement placed at the
beginning of the input source file.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-09270: szalloc: error allocating memory for security

1 Answers  


ORA-26503: internal RepAPI operation failure on object string.string

1 Answers  


ORA-13422: invalid model coordinate parameter

1 Answers  


RMAN-08093: specifying current controlfile for proxy backup

1 Answers  


LSX-00118: fixed facet value cannot be changed

1 Answers  






PLS-00632: NOT INSTANTIABLE method cannot have a body

1 Answers  


TNS-02022: show rules: Show rules that are currently in effect

1 Answers  


ORA-08458: invalid format parameter

1 Answers  


ORA-36403: (XSBADSPROP) number is an illegal value for system-reserved property string on workspace object.

1 Answers  


ORA-38311: cannot purge objects owned by other users

1 Answers  


NNC-00420: operation not allowed

1 Answers  


PLS-00630: pipelined functions must have a supported collection return type

2 Answers  


Categories