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 |
DRG-11812: Moved Permanently
RMAN-06263: %-4s string string
ORA-30364: this level has the same set of columns as another
ORA-32735: DIAG process is not running in the instance
RMAN-06472: channel id string is automatically allocated
SQL*Loader-00114: Error in OPTIONS statement
ORA-06702: TLI Driver: cannot allocate context area
RMAN-06146: changes found for file number beyond offline SCN
ORA-00084: global area must be PGA, SGA, or UGA
ORA-23322: Privilege error accessing pipe
ORA-09706: slsget: get_process_stats error.
ORA-36157: (XSMXAGGRCOMMIT) To use the AUTOCOMMIT keyword, you must also specify the AUTOUPDATE keyword.