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