This content has been marked as final. Show 1 reply
As the error message indicates, PLS-00306 occurs when you supply the wrong number or wrong types or arguments.
What are the types of arguments?
The two things that come to mind are:
1) ORAOLEDB doesnt support ref cursors from procedures by default if I recall correctly. You need to enable it via PLSQLRSET
2) MSDAORA uses a proprietary syntax (http://support.microsoft.com/kb/229919) for getting result sets from stored procedures, that the Oracle provider doesn't
Short of that, you'll just need to verify what specific operation is occurring when the error occurs, via client side sqlnet trace for example.
Hope it helps,