Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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-03296: cannot resize datafile - file string not found

1 Answers  


ORA-09314: sltln: error translating logical name

1 Answers  


QSM-02088: mv omits at least one grouping key from the select list

1 Answers  


ORA-22970: name does not correspond to an object view

1 Answers  


ORA-12528: TNS:listener: all appropriate instances are blocking new connections

2 Answers  


RMAN-08580: channel string: starting datafile copy

1 Answers  


QSM-01038: logical operator(s) could not be processed

1 Answers  


LPX-00248: invalid entity declaration

1 Answers  


DRG-50920: part of phrase not itself a phrase or equivalence

1 Answers  


ORA-06515: PL/SQL: unhandled exception string

1 Answers  


NNL-00500: Shows information on domains served by this server

1 Answers  


QSM-01052: referential integrity constraint on table, string, not VALID in ENFORCED integrity mode

1 Answers  


Categories