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

NNL-00581: unregister_ns: <name server> <domain>

1 Answers  


PCB-00635: This attribute is only valid for Internal LOB types

1 Answers  


TNS-00076: component by specifying the component name in

1 Answers  


ORA-18015: invalid source outline signature

1 Answers  


TNS-01044: %s(Registered) has string service handler(s)

1 Answers  


ORA-22163: left hand and right hand side collections are not of same type

1 Answers  


PCC-00009: Invalid host variable at column number in line number of file string

1 Answers  


ORA-00214: controlfile 'string' version string inconsistent with file 'string' version string

1 Answers  


ORA-22625: OCIAnyData is not well-formed

1 Answers  


LFI-01515: truncate() failed.

1 Answers  


TNS-01167: The command string is not supported by the listener contacted

1 Answers  


NNL-00890: Messages received: number

1 Answers  


Categories