My Oracle Support Banner

Execution of ALTER TABLE Statement Dynamically Using Execute Immediate Fails with ORA-14047 (Doc ID 2991676.1)

Last updated on JULY 20, 2024

Applies to:

PL/SQL - Version 19.19.0.0.0 and later
Information in this document applies to any platform.

Symptoms

An 'ALTER TABLE' statement issued from a PLSQL block fails with "ORA-14047: ALTER TABLE|INDEX RENAME may not be combined with other operations" error though the same statement works fine outside the block. The issue can be demonstrated using the following testcase where a table is attempted to be renamed from an anonymous block.

Changes

It is the first time the table is attemted to be renamed dynamically.

Cause

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
Symptoms
Changes
Cause
Solution


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