PCC-02206: Host variables are not permitted within a DDL
statement



PCC-02206: Host variables are not permitted within a DDL statement..

Answer / guest

Cause: A Data Definition Language statement cannot use host
variables. For example, the statement CREATE TABLE
:table_name (c1 char(10)); is illegal, because the name of
the table in a CREATE TABLE statement cannot be represented
using host variable.

Action: Use dynamic SQL to create the names of database
objects (tables, views, columns, etc.) at runtime. See the
Programmer's Guide to the Oracle Precompilers, Release2.2
for information about dynamic SQL.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NZE-28783: invalid parameter

1 Answers  


IMG-00831: boundary queue size exceeds expected size

1 Answers  


ORA-22332: a dependent object in schema "string" has errors. string

1 Answers  


ORA-31058: cannot modify read-only XOBs

1 Answers  


CLSR-00522: Resource string is not registered

1 Answers  






TNS-00513: Destination host unreachable

1 Answers  


ORA-01028: internal two task error

1 Answers  


ORA-13127: failed to generate target partition

1 Answers  


ORA-08414: error encountered in string

1 Answers  


ORA-25265: specified signature for a queue which does not support reciever non-repudiation

1 Answers  


ORA-27451: %s cannot be NULL

1 Answers  


ORA-29903: error in executing ODCIIndexFetch() routine

1 Answers  


Categories