Calling oracle stored procedure from Excel - VBA
- by Ram
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.
