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

PLS-00118: Duplicate group-by clause in table expression

1 Answers  


ORA-08263: ora_addr: cannot free listener address

1 Answers  


ORA-16751: Resource guard encountered errors in switchover to primary

1 Answers  


RMAN-06738: database name "string" is not unique in the recovery catalog

1 Answers  


ORA-16590: no primary established in Data Guard configuration

1 Answers  






O2U-00202: Invalid data passed to function

1 Answers  


DRG-50704: Net8 listener is not running or cannot start external procedures

1 Answers  


ORA-06747: TLI Driver: error in listen

1 Answers  


ORA-09946: File name too long for buffer

1 Answers  


ORA-09209: sftget: error reading from file

1 Answers  


ORA-38726: Flashback database logging is not on.

1 Answers  


DRG-10849: catsearch does not support functional invocation

1 Answers  


Categories