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-24370: illegal piecewise operation attempted

1 Answers  


ORA-09240: smpalo: error allocating PGA memory

1 Answers  


ORA-16952: Failed to bind this SQL statement.

1 Answers  


ORA-00235: controlfile fixed table inconsistent due to concurrent update

1 Answers  


RMAN-08510: archive log thread=string sequence=string

1 Answers  


CLSR-00509: Unable to initialize NLS

1 Answers  


PCB-00222: Size for host variable string exceeds maximum size

1 Answers  


LPX-00661: Failed to load: '~s'.

1 Answers  


QSM-01060: illegal subquery in the HAVING clause

1 Answers  


ORA-03212: Temporary Segment cannot be created in locally-managed tablespace

1 Answers  


TNS-00011: INTCTL: error while starting the Connection Manager

1 Answers  


ORA-15197: suppressing string additional ASM messages

1 Answers  


Categories