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-25245: agent name cannot be specified if address is a single-consumer queue or an exception queue

1 Answers  


ORA-04082: NEW or OLD references not allowed in table level triggers

2 Answers   Satyam,


O2I-00102: Unable to connect to Oracle

1 Answers  


ORA-13264: geometry identifier column string does not exist in table string

1 Answers  


QSM-01033: query rewritten with materialized view, string

1 Answers  


ORA-16012: Archive log standby database identifier mismatch

1 Answers  


DRG-11841: Bad Gateway

1 Answers  


DRG-12212: error while dropping section string

1 Answers  


NNL-00804: Queries received, type META-DATA: number

1 Answers  


ORA-16811: apply instance not recorded by the Data Guard broker

1 Answers  


LRM-00111: no closing quote for value 'string'

1 Answers  


ORA-15130: diskgroup "string" is being dismounted

1 Answers  


Categories