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-07488: scgrcl: lock manager not initialized.

1 Answers  


KUP-11008: conversion error loading table string.string partition string

1 Answers  


LSX-00174: "~S" is not a valid derivation of "~S"

1 Answers  


NNL-00834: Slowest delete processing time: string

1 Answers  


ORA-28267: Invalid name for NameSpace

1 Answers  






NNL-00006: timeout, server is not responding

1 Answers  


SQL*Loader-00935: Error verifying required option for parallel load.

1 Answers  


ORA-07254: spdcr: translation error while expanding ?/bin/oracle.

1 Answers  


ORA-31427: publication string already subscribed

1 Answers  


ORA-09802: Conversion of binary label to string failed.

1 Answers  


ORA-32833: failure string trying to release administration lock

1 Answers  


LCD-00219: nested include file [string] is too large

1 Answers  


Categories