How to fix the Oracle error PCC-02362: Host variable not declared within SQL DECLARE section?

In this post, you’ll learn more about the Oracle ErrorPCC-02362: Host variable not declared within SQL DECLARE section with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

Reason for the Error PCC-02362: Host variable not declared within SQL DECLARE section

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.

How to fix the Error PCC-02362: Host variable not declared within SQL DECLARE section ?

You can fix this error in Oracle by following the below steps

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