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 |
ORA-38731: Expected version string does not match string in log header.
NPL-00302: ASN.1 type tag is greater than maximum of 16383
PCC-00016: Unable to open a cursor at line number in file string
ORA-28302: User does not exist in the LDAP directory service.
SQL*Loader-00254: Cannot have DISCARDFILE specs here when multiple data files
ORA-29932: the type being dropped is a statistics type
ORA-13241: specified dimensionality does not match that of the data
ORA-32153: Environment not specified
O2U-00209: Attribute or function name to be translated was not found
ORA-23413: table "string"."string" does not have a materialized view log
ORA-26017: global indexes not allowed for direct path load of table partition string
ORA-06555: this name is currently reserved for use by user SYS