Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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-37006: (AWLISTALL04) number writers

1 Answers  


RMAN-00555: target database connect string must be specified

1 Answers  


ORA-34897: (PPMONTHS01) Blank lines are not allowed in the MONTHNAMES option.

1 Answers  


ORA-01343: LogMiner encountered corruption in the logstream

1 Answers  


DRG-11001: missing keyword when expecting one of string

1 Answers  


NZE-28754: object storage failure

1 Answers  


PCC-00082: Length and scale specifications must be an integer

1 Answers  


RMAN-06186: PL/SQL package string.string version string in string database is too old

1 Answers  


ORA-07824: sspain: $SETIMR failure

1 Answers  


TNS-00042: INTCTL: CMANAGER already running. Start operation cancelled

1 Answers  


RMAN-08520: channel string: scanning archive log string

1 Answers  


ORA-02162: invalid value for MAXDATAFILES

1 Answers  


Categories