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-13861: Statistics aggregation for client identifier string is already enabled

1 Answers  


NNL-00562: unregister <name> [-d<address>] [-l<listener_name>] : unregister an object with Oracle Names

1 Answers  


ORA-29817: non-supported option with disassociate statement

1 Answers  


KUP-03015: OCI error getting datetime lfprecision.

1 Answers  


ORA-23325: parameter type is not string

1 Answers  






ORA-06713: TLI Driver: error on connect

1 Answers  


ORA-36875: (XSFTDSC05) LIMITMAP is missing or is not a string literal.

1 Answers  


NNF-03004: DNS Class mismatch (string)

1 Answers  


RMAN-06024: no backup or copy of the controlfile found to restore

1 Answers  


ORA-09366: Windows 3.1 Two-Task driver unable to allocate shared memory

1 Answers  


ORA-32600: RETENTION and PCTVERSION cannot be used together

1 Answers  


TNS-00138: Failed to find ORACLE executable directory

1 Answers  


Categories