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

ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column

1 Answers  


ORA-27154: post/wait create failed

1 Answers  


ORA-29892: indextypes with array DML do not support the given data type

1 Answers  


ORA-14290: PRIMARY KEY constraint mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION

1 Answers  


RMAN-20029: cannot make a snapshot controlfile

1 Answers  






ORA-36980: (XSRELGID02) Variable workspace object must have a numeric data type.

1 Answers  


ORA-02833: Server was unable to close file

1 Answers  


ORA-12714: invalid national character set specified

1 Answers  


ORA-01340: NLS error

1 Answers  


NNL-00233: Auto-refresh failure-retry interval is now string

1 Answers  


ORA-09769: osnmbr: cannot send break message

1 Answers  


ORA-04015: ascending sequences that CYCLE must specify MAXVALUE

1 Answers  


Categories