How to fix the Oracle error PCC-01009: For hostlan = COB74, a SQL statement must be followed by ELSE or “.”?

In this post, you’ll learn more about the Oracle ErrorPCC-01009: For hostlan = COB74, a SQL statement must be followed by ELSE or “.” with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PCC-01009: For hostlan = COB74, a SQL statement must be followed by ELSE or “.”

Reason for the Error PCC-01009: For hostlan = COB74, a SQL statement must be followed by ELSE or “.”

Cause: In a Pro*COBOL program, an EXEC SQL statement is followed by another statement in the same sentence. An EXEC SQL statement must be the last statement in a COBOL-74 sentence and so must be terminated by the keyword ELSE or a period.

How to fix the Error PCC-01009: For hostlan = COB74, a SQL statement must be followed by ELSE or “.” ?

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

Action: Change the program logic, making the EXEC SQL statement the last statement in the sentence.