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-04051: user string cannot use database link string.string

1 Answers  


ORA-16200: Skip procedure requested to skip statement

1 Answers  


ORA-28044: unsupported directory type

1 Answers  


ORA-25295: Subscriber is not allowed to dequeue buffered messages

1 Answers  


ORA-25299: Cannot add buffered subscriber for a non-buffered queue

1 Answers  


PROT-00015: Unimplemented feature

1 Answers  


DRG-11705: multilevel jump from string to string

1 Answers  


ORA-16762: Invalid database state

1 Answers  


ORA-02837: Unable to unlink temporary file

1 Answers  


ORA-03215: File Size specified for resize is too small

1 Answers  


ORA-00703: maximum number of row cache instance locks exceeded

1 Answers  


ORA-12550: TNS:syntax error

1 Answers  


Categories