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-29832: cannot drop or replace an indextype with dependent indexes

1 Answers  


ORA-19621: archivelog range has already been specified

1 Answers  


ORA-01118: cannot add any more database files: limit of string exceeded

1 Answers  


UDI-00051: unable to set NLS_NUMERIC_CHARACTERS to required defaults.

1 Answers  


LFI-01518: write() failed(OSD return value = string) in string.

1 Answers  


ORA-07614: $CHANGE_CLASS failed in retrieving the user's process label

1 Answers  


NID-00481: DBNEWID - Cancelled.

1 Answers  


IMP-00084: attempt to mix incremental import with user or table import

1 Answers  


ORA-13443: GeoRaster metadata SRS error

1 Answers  


ORA-32167: No payload set on the Message

1 Answers  


ORA-08236: smsget: cannot share subcube with listener

1 Answers  


NCR-01018: NCRS: Encryption failure.

1 Answers  


Categories