Calling Oracle Procedure within Excel
411757Feb 8 2006 — edited Feb 10 2006I am trying to figure out how to call a parameterized stored procedure from within Excel. I am getting an error back of "-2147217900 (80040e14)" and this error basically means the query has something invalid in it.
I failing on the following command
cmd.Parameters.Refresh
And I guess this command is suppose to initialize the parameters of my command object.
I found a KB article in MS which indicated that the one of the reasons for the error is that the incorrect provider is being used. I check it and my code agrees with the solution.
I thought that I could use an native Oracle driver, but None show up for me when I am excel. I know that I have the 9.2 drivers loaded because I am using those in my .Net Development, but I am guessing that these are just for use with the .Net product.
Any ideas how to solve the problem?
Are there native drivers that I can install and utilize those drivers instead?
Thanks in advance for your assistance.