How to fix the Oracle error PCC-02373: Invalid declaration in EXEC SQL DECLARE section?

In this post, you’ll learn more about the Oracle ErrorPCC-02373: Invalid declaration in EXEC SQL DECLARE section with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PCC-02373: Invalid declaration in EXEC SQL DECLARE section

Reason for the Error PCC-02373: Invalid declaration in EXEC SQL DECLARE section

Cause: An improper declaration was placed in a Declare Section. This message is usually caused by including an EXEC SQL TYPE or EXEC SQL VAR declaration in a Declare Section.

How to fix the Error PCC-02373: Invalid declaration in EXEC SQL DECLARE section ?

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

Action: Move the declaration outside of the SQL DECLARE section.