Precompiler Throws PCC-S-02201 with the SQL REPLACE Statement
(Doc ID 1396714.1)
Last updated on JULY 16, 2019
Applies to:Precompilers - Version: 18.104.22.168
Information in this document applies to any platform.
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:
CREATE PROCEDURE P1 AS
select replace ('FRED', 'FR', 'B') into x from dual;
EXEC SQL CREATE TABLE test AS select replace ('FRED', 'FR', 'B') bed from dual;
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
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|