Calling oracle stored procedure from Excel - VBA

Posted by Ram on Stack Overflow See other posts from Stack Overflow or by Ram
Published on 2010-03-11T05:58:31Z Indexed on 2010/03/11 17:59 UTC
Read the original article Hit count: 647

I have to execute an Oracle stored procedure from vba (Excel) with around 38 input parameters. The
stored procedure will insert some values in the destination table once that is executed. When it is executed through VBA the number of fields which is inserted is less than when it is executed directly from the backend (oracle).

For example it is creating around 17 fields of records while executing directly from the back end. (I have created a wrapper class in the back-end and passing the same parameter values in the back-end.). It is creating around 15 fields of records while executing from the excel VBA in the destination table.

Kindly let me know what could be the possible reasons for this.

© Stack Overflow or respective owner

Related posts about excel-vba

Related posts about Oracle