PCB-00554: Must include SQLCA when mode=ANSI and WHENEVER
SQLWARNING used



PCB-00554: Must 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

NZE-28786: decryption of encrypted private key failure

1 Answers  


ORA-16021: session string destination cannot be the same as session string destination

1 Answers  


ORA-40220: maximum number of attributes exceeded

1 Answers  


O2F-00324: Unable to convert from the database character set to the compiler character set

1 Answers  


ORA-22277: cannot use two different locators to modify the same LOB

1 Answers  






ORA-00356: inconsistent lengths in change description

1 Answers  


NNO-00304: listen address string length string exceeds maximum of string

1 Answers  


LSX-00206: substitution for element "~S" is disallowed

1 Answers  


ORA-23482: column string of "string"."string": object types not allowed.

1 Answers  


ORA-08440: raw buffer is too short to hold converted data

1 Answers  


RMAN-06203: Changed KEEP options for string objects

1 Answers  


ORA-19683: real and backup blocksize of file string are unequal

1 Answers  


Categories