PCC-00083: Bind and define variables not allowed in CREATE
statement



PCC-00083: Bind and define variables not allowed in CREATE statement..

Answer / guest

Cause: Host variables cannot appear in a CREATE statement.
If the makeup of a CREATE statement cannot be known until
run time, a dynamic SQL statement must be used to execute
it. That is, the program must accept or build the CREATE
statement at run time, store it in a host string, then
EXECUTE it.

Action: Correct or remove the erroneous CREATE statement.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-16083: LogMiner session has not been created

1 Answers  


ORA-12546: TNS:permission denied

1 Answers  


ORA-24030: Only one of rule or rule-set must be specified

1 Answers  


ORA-30730: referential constraint not allowed on nested table column

1 Answers  


ORA-39054: missing or invalid definition of the SQL output file.

1 Answers  






TNS-00121: Missing CMANAGER_NAME in INTCHG.ORA

1 Answers  


ORA-14047: ALTER TABLE|INDEX RENAME may not be combined with other operations

1 Answers  


SQL*Loader-00472: collections can contain only one non FILLER field specification

1 Answers  


TNS-00072: * start - start up process_name

1 Answers  


ORA-00721: changes by release string cannot be used by release string

1 Answers  


IMP-00056: multiple devices specified for tape input

1 Answers  


CLSS-01200: skgxn errror: category string, operation string, loc string

1 Answers  


Categories