PCC-00042: Must EXEC SQL INCLUDE SQLCA when mode=ANSI and
WHENEVER SQLWARNING used
- 1 Answers
- 2218 Views
- I also Faced
- E-Mail Answers
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 |
ORA-01194: file string needs more recovery to be consistent
ORA-19035: Invalid select item of the query in newContextFromHierarchy()
ORA-36964: (XSRELTBL09) workspace object is not a valid level relation.
ORA-30395: dimension options require the COMPATIBLE parameter to be string or greater
NNO-00709: failed delete of cache checkpoint file "string", cache flush may not work
PCC-01000: You are not authorized to run Pro*COBOL
QSM-00506: no fact-tables could be found
ORA-36716: (XSMXALLOC04) You can only use the ACROSS phrase when allocation BASIS workspace object is a FORMULA.
ORA-38775: cannot disable flash recovery area - flashback database is enabled
ORA-09762: sNeXT_instanceName: translation error.
ORA-30053: invalid upper limit snapshot expression
ORA-16206: database already configured as Logical Standby database
Oracle Errors 
