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

DRG-11812: Moved Permanently

1 Answers  


RMAN-06263: %-4s string string

1 Answers  


ORA-30364: this level has the same set of columns as another

1 Answers  


ORA-32735: DIAG process is not running in the instance

1 Answers  


RMAN-06472: channel id string is automatically allocated

1 Answers  


SQL*Loader-00114: Error in OPTIONS statement

1 Answers  


ORA-06702: TLI Driver: cannot allocate context area

1 Answers  


RMAN-06146: changes found for file number beyond offline SCN

1 Answers  


ORA-00084: global area must be PGA, SGA, or UGA

1 Answers  


ORA-23322: Privilege error accessing pipe

1 Answers  


ORA-09706: slsget: get_process_stats error.

1 Answers  


ORA-36157: (XSMXAGGRCOMMIT) To use the AUTOCOMMIT keyword, you must also specify the AUTOUPDATE keyword.

1 Answers  


Categories