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-36692: (XSRELTBL00) The format of the HIERHEIGHT command is: HIERHEIGHT relation1[(dimension dimvalue, ...)] into relation2 [using relation3 | a | d] [inhierarchy {variable | valueset}].

1 Answers  


RMAN-08104: input backupset count=string stamp=string creation_time=string

1 Answers  


RMAN-06005: connected to target database: string (DBID=string)

1 Answers  


ORA-31517: CDC change table string.string already exists

1 Answers  


ORA-16547: cannot disable the primary database

1 Answers  


ORA-09772: osnpmetbrkmsg: message from host had incorrect message type

1 Answers  


ORA-33284: (DBERR12) Analytic workspace string cannot be opened in MULTI mode before converting it by the latest version of string.

1 Answers  


ORA-16800: Log transport service for some database is incorrectly set to ALTERNATE.

1 Answers  


ORA-31073: Resource not retrieved using path name

1 Answers  


ORA-22892: scoped table "string" does not exist in schema "string"

1 Answers  


ORA-02058: no prepared transaction found with ID string

1 Answers  


ORA-13435: GeoRaster metadata dimension inconsistent

1 Answers  


Categories