Database Error Messages

Release
toggle
  • 23ai
  • 21c
Updated
Jun 24, 2024

ORA-01066

Placeholder substitution failed.

Cause

Either OCIStmtPlaceholderSubstitute() was called after OCIStmtExecute(), or the statement was prepared without specifying the mode OCI_PREP2_OCI_PLACEHOLDER to OCIStmtPrepare2().


Action

  1. Prepare the statement using OCIStmtPrepare2() with mode OCI_PREP2_OCI_PLACEHOLDER before calling OCIStmtPlaceholderSubstitute().
  2. Call OCIStmtPlaceholderSubstitute() before calling OCIStmtExecute().