Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


PCC-02362: Host variable not declared within SQL DECLARE section



PCC-02362: Host variable not declared within SQL DECLARE section..

Answer / guest

Cause: When MODE=ANSI is specified at precompile time, all
host variables must be declared inside Declare Sections.
Remember that MODE=ANSI refers to ANSI SQL, not ANSI C.

Action: Add the EXEC SQL BEGIN DECLARE SECTION... EXEC SQL
END DECLARE SECTION statements around all host variable
declarations.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

DRG-10758: index owner does not have the privilege to use this preference

1 Answers  


ORA-38459: XML Tag "string" not found for the XMLType attribute "string"

1 Answers  


RMAN-10004: unable to connect to recovery catalog

1 Answers  


RMAN-03039: Spooling for log turned off

1 Answers  


SQL*Loader-00647: Integer to number conversion error

1 Answers  






QSM-02049: subquery using the ANY clause in mv

1 Answers  


ORA-07426: spstp: cannot obtain the location of dbs directory.

1 Answers  


ORA-01161: database name string in file header does not match given name of string

2 Answers  


ORA-09940: ORACLE password file header is corrupt

1 Answers  


ORA-02213: duplicate PCTUSED option specification

1 Answers  


QSM-01017: aggregate argument cannot be converted to canonical form

1 Answers  


TNS-12547: TNS:lost contact

1 Answers  






Categories