question

RM-5397 avatar image
0 Votes"
RM-5397 asked

Excel VBA. Call Oracle Stored Procedure with Parameters

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.

dotnet-adonet
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

0 Answers