Stored Procedure Default Parameter Values Does Not Work With OLEDB Provider (Doc ID 2400004.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Symptoms

OLEDB application calling oracle stored procedure which is decorated with default parameter value normally if there is no parameter passed from the application to the stored procedure. It will take the default values defined in the procedure and execute.But if we calls the same procedure without passing any value to the default parameter using ADODB.COMMAND object fails with below error because it is not taking the default parameter value defined in the stored procedure.

Error:

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.