ADO/VBA and Oracle Stored Procedure / wms_container_pub.generate_lpn
I've been using ADO/VBA to called oracle stored procedures using ADODB Commands (works fine).
I'm having trouble using the wms_container_pub.generate_lpn api.
The above function has a number of optional parameters. If I only define ADO params for the required input and output params in the function, I get the "PLS-00306: wrong number or types of arguments" error message.
If I define ADO params for every input and output param in the function, the command.execute either returns a failed message ("E" for the return_status output), or I get "ODBC driver does not support the requested properties".
Questions:
1. Do I need to explicitly specify optional input params in ADO for an Oracle api?
2. If yes, how do I specify params that I'm not using for Number and Varchar2 input params?
I'm using Oracle 10g Client, Access 2010/VBA.
I can post code tomorrow if needed. Thanks in advance for any suggestions.