This page provides more detailed information about the
OCIStmtPlaceholderSubstitute() substitutes placeholder strings in SQL statements. Placeholders can be specified in only those statements that cannot have bind variables. OCI placeholders are not the same as bind variables.
The statements that cannot have OCI placeholders are those beginning with keywords such as
FLASHBACK because they support bind variables. Other SQL statements such as
EXPLAIN statements can have OCI placeholders.
The parameters of the
OCIStmtPlaceholderSubstitute() function are defined in the Oracle® Call Interface Programmer's Guide 21c.