Stored Procedure Default Parameter Values Does Not Work With OLEDB Provider
(Doc ID 2400004.1)
Last updated on FEBRUARY 08, 2019
Applies to:
Oracle Provider for OLE DB - Version 12.1.0.2 and laterMicrosoft 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! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |