How to fix the Oracle error PCC-00054: Expected End-of-Statement at column number in line number of file string?

In this post, you’ll learn more about the Oracle ErrorPCC-00054: Expected End-of-Statement at column number in line number of file string with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PCC-00054: Expected End-of-Statement at column number in line number of file string

Reason for the Error PCC-00054: Expected End-of-Statement at column number in line number of file string

Cause: The precompiler expected to find a statement terminator at the end of an EXEC statement but found something else. This can happen if tabs were embedded in the source code (because the precompiler has no way of knowing how many spaces a tab represents).

How to fix the Error PCC-00054: Expected End-of-Statement at column number in line number of file string ?

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

Action: If tabs are embedded in the source ocde, replace them with spaces. Check the statement syntax and check that each EXEC statement has a terminator. For embedded CREATE {FUNCTION | PROCEDURE | PACKAGE} statements and for embedded PL/SQL blocks, check that the statement terminator is END-EXEC.