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

QSM-02138: agg(expr) requires correspondng agg(expr*expr) function

1 Answers  


ORA-24759: invalid transaction start flags

1 Answers  


ORA-27481: "string.string" has an invalid schedule

1 Answers  


ORA-32331: type "string"."string" is incompatible with the master site

1 Answers  


ORA-31216: DBMS_LDAP: PL/SQL - Invalid LDAP rdn.

1 Answers  






NNL-00568: delegate_domain <domain_name> <NS_name> <NS_Addr> : Delegate the given domain to the given nameserver

1 Answers  


DRG-13303: value of wildcard offset must be in the range string..string, at line string

1 Answers  


EXP-00074: rounding VOLSIZE down, new value is string

1 Answers  


TNS-00114: Internal error- Allocation of addresses not performed

1 Answers  


ORA-24154: rule string.string already in rule set string.string

1 Answers  


ORA-33462: (ESDREAD10A) Discarding compiled code for workspace object because object number is not in analytic workspace string.

1 Answers  


RMAN-06411: backup copies setting out of range (1-4): number

1 Answers  


Categories