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-26076: cannot set or reset value after direct path structure is allocated

0 Answers  


ORA-29390: some resource plans are not part of any top-plan

1 Answers  


ORA-16774: Error in stopping the physical apply service (MRP process)

1 Answers  


ORA-01287: file string is from a different database incarnation

1 Answers  


ORA-00308: cannot open archived log 'string'

1 Answers  






ORA-24041: propagation schedule exists for QUEUE string and DESTINATION string

1 Answers  


ORA-24780: cannot recover a transaction while in an existing transaction

1 Answers  


ORA-00337: log file 'string' does not exist and no size specified

1 Answers  


ORA-25230: invalid value string, WAIT should be non-negative

1 Answers  


PCC-02047: CMD-LINE: Option is not allowed inline:

1 Answers  


PCB-00311: Datatype equivalencing is an Oracle extension

1 Answers  


KUP-04047: error parsing record from external data source

1 Answers  


Categories