Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

ORA-32587: Cannot drop nonexistent string supplemental logging

1 Answers  


ORA-24903: invalid namespace attribute passed into OCI call

1 Answers  


ORA-31197: Error in processing file string

1 Answers  


ORA-06764: TLI Driver: error reading disconnect

1 Answers  


EXP-00008: ORACLE error number encountered

1 Answers  






ORA-24332: invalid object type

1 Answers  


ORA-02058: no prepared transaction found with ID string

1 Answers  


ORA-07206: slgtd: gettimeofday error, unable to obtain time.

1 Answers  


ORA-16051: parameter string contains an invalid delay time

1 Answers  


ORA-39051: parameter string specified multiple times

1 Answers  


CLSR-00517: Failed to register a service name

1 Answers  


KUP-11010: unable to open at least one dump file for load

1 Answers  






Categories