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-38731: Expected version string does not match string in log header.

1 Answers  


NPL-00302: ASN.1 type tag is greater than maximum of 16383

1 Answers  


PCC-00016: Unable to open a cursor at line number in file string

1 Answers  


ORA-28302: User does not exist in the LDAP directory service.

1 Answers  


SQL*Loader-00254: Cannot have DISCARDFILE specs here when multiple data files

1 Answers  


ORA-29932: the type being dropped is a statistics type

1 Answers  


ORA-13241: specified dimensionality does not match that of the data

1 Answers  


ORA-32153: Environment not specified

1 Answers  


O2U-00209: Attribute or function name to be translated was not found

1 Answers  


ORA-23413: table "string"."string" does not have a materialized view log

1 Answers  


ORA-26017: global indexes not allowed for direct path load of table partition string

1 Answers  


ORA-06555: this name is currently reserved for use by user SYS

1 Answers  


Categories