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


PCC-00042: Must EXEC SQL INCLUDE SQLCA when mode=ANSI and
WHENEVER SQLWARNING used



PCC-00042: Must EXEC SQL INCLUDE SQLCA when mode=ANSI and WHENEVER SQLWARNING used..

Answer / guest

Cause: When MODE={ANSI | ANSI14}, an attempt was made to use
the WHENEVER SQLWARNING statement without declaring the
SQLCA. When MODE={ANSI | ANSI14}, declaring the SQLCA is
optional, but to use the WHENEVER SQLWARNING statement, the
SQLCA must be declared.

Action: Remove all WHENEVER SQLWARNING statements from the
program or declare the SQLCA by hardcoding it or copying it
into the program with the INCLUDE statement.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-13348: polygon boundary is not closed

1 Answers  


ORA-29905: method string does not exist in type string.string

1 Answers  


RMAN-05001: auxiliary filename string conflicts with a file used by the target database

1 Answers  


ORA-24041: propagation schedule exists for QUEUE string and DESTINATION string

1 Answers  


ORA-07273: sppst: invalid semaphore id.

1 Answers  






ORA-16588: no more internal buffers

1 Answers  


RMAN-06746: backup cancelled because all files were skipped

1 Answers  


TNS-00084: * trace_off - ask process name to turn tracing off

1 Answers  


LPX-00221: the character "<" cannot occur in attribute values

1 Answers  


ORA-12680: Native services disabled but required

1 Answers  


ORA-19208: parameter string of function string must be aliased

1 Answers  


ORA-38767: flashback retention target parameter mismatch

1 Answers  






Categories