My Oracle Support Banner

Precompiler Throws PCC-S-02201 with the SQL REPLACE Statement (Doc ID 1396714.1)

Last updated on JANUARY 06, 2020

Applies to:

Precompilers - Version and later
Information in this document applies to any platform.


Pro*C fails to recognise the SQL REPLACE function and throws a syntax error at compilation:

PCC-S-02201, Encountered the symbol "REPLACE" when expecting one of the following:
; end-exec, table, or, random_terminal function, package,
procedure, type, schema, trigger, view, role, constraints,
The symbol "; was inserted before "REPLACE" to continue.

Error at line 0, column 0 in file sample2.pc
PCC-F-02102, Fatal error while doing C preprocessing

This only happens with embedded DDL statements.  For example:


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.