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-29033: Invalid PFX

1 Answers  


LFI-00109: Unable to open file [string][string]. string.

1 Answers  


SQL*Loader-00627: Character set conversion graph not available.

1 Answers  


ORA-39127: unexpected error from call to string string

1 Answers  


ORA-30185: output too large to fit in the buffer

1 Answers  


QSM-01073: materialized view, string, has a join not found in query

1 Answers  


ORA-23444: duplicate template parameter

1 Answers  


ORA-31426: cannot modify active subscriptions

1 Answers  


ORA-28670: mapping table cannot be dropped due to an existing bitmap index

1 Answers  


DRG-10513: index string metadata is corrupt

1 Answers  


SQL*Loader-00530: OCI return status: need data

1 Answers  


ORA-16011: Archivelog Remote File Server process in Error state

1 Answers  


Categories