My Oracle Support Banner

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

Last updated on MAY 24, 2018

Applies to:

Oracle Provider for OLE DB - Version 12.1.0.2 and later
Microsoft Windows (32-bit)
Microsoft Windows x64 (64-bit)

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

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