Details: Placeholders in SQL Statements

This page provides more detailed information about the OCIStmtPlaceholderSubstitute() function. 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 SELECT, UPDATE, DELETE, INSERT, BEGIN, DECLARE, RETURNING, CALL, MERGE, ROLLBACK, COMMIT, and FLASHBACK because they support bind variables. Other SQL statements such as CREATE, DROP, ALTER, EXPLAIN statements can have OCI placeholders.

The parameters of the OCIStmtPlaceholderSubstitute() function are defined in the Oracle® Call Interface Programmer's Guide 21c.