I am using Oracle 11g and Excel 360.
I need to call an Oracle stored procedure in Excel VBA. I will pass 3 parameters to Oracle and it will return a grand total. The 3 parameters are Job ID, start date and end date. Then Oracle procedure will give me the grand total for that job ID for those dates.
What's the ADO syntax for this.
I have looked all over the Net but so far I have not found something that works.