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

ORA-30930: NOCYCLE keyword is required with CONNECT_BY_ISCYCLE pseudocolumn

1 Answers  


RMAN-08548: recovery area destination: string

1 Answers  


ORA-30749: column string not enabled to store objects of type string.string

1 Answers  


ORA-32817: message system link string is not configured with a log queue for string

1 Answers  


ORA-32163: Method called on Invalid Environment type

1 Answers  






DRG-11502: read of file failed at line string for file string

1 Answers  


ORA-32613: not a MODEL cell

1 Answers  


ORA-30456: 'string.string' cannot be refreshed because of insufficient privilege

1 Answers  


ORA-26519: no memory available to allocate

1 Answers  


PLS-00498: illegal use of a type before its declaration

1 Answers  


ORA-12020: materialized view string is not registered

1 Answers  


ORA-24000: invalid value string, string should be of the form [SCHEMA.]NAME

1 Answers  


Categories