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-01194: file string needs more recovery to be consistent

1 Answers  


ORA-19035: Invalid select item of the query in newContextFromHierarchy()

1 Answers  


ORA-36964: (XSRELTBL09) workspace object is not a valid level relation.

1 Answers  


ORA-30395: dimension options require the COMPATIBLE parameter to be string or greater

1 Answers  


NNO-00709: failed delete of cache checkpoint file "string", cache flush may not work

1 Answers  






PCC-01000: You are not authorized to run Pro*COBOL

1 Answers  


QSM-00506: no fact-tables could be found

1 Answers  


ORA-36716: (XSMXALLOC04) You can only use the ACROSS phrase when allocation BASIS workspace object is a FORMULA.

1 Answers  


ORA-38775: cannot disable flash recovery area - flashback database is enabled

2 Answers  


ORA-09762: sNeXT_instanceName: translation error.

1 Answers  


ORA-30053: invalid upper limit snapshot expression

1 Answers  


ORA-16206: database already configured as Logical Standby database

1 Answers  






Categories