Command Parameters

Parameters are marked in command text with the ODBC-specified question mark (?) character. For example, the following ODBC SQL statement is marked for a single input parameter:

{call CREDIT_TO_ACCOUNT(123456,?)}

The OLE DB Provider for Oracle supports input parameters in SQL statement commands. On procedure-call commands, this provider supports input, output, and input/output parameters. Output parameter values are returned to the application on execution.

The names of stored procedure parameters need not be specified in a DBPARAMBINDINFO structure. Use NULL for the value of the pwszName member to indicate that the provider should ignore the parameter name and use only the ordinal specified in the rgParamOrdinals member of ICommandWithParameters::SetParameterInfo.

If the name of a stored procedure parameter is specified, the OLE DB Provider for Oracle checks the name to ensure that it is valid. The OLE DB Provider for Oracle returns an error when it receives an erroneous parameter name from the consumer.