OLE DB Provider for Oracle

Command Parameters

The OLE DB Provider for Oracle supports multiple parameter sets on the command object.

The Oracle provider 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.

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

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.