Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Calling Oracle Procedure within Excel

411757Feb 8 2006 — edited Feb 10 2006
I 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 10 2006
Added on Feb 8 2006
4 comments
11,442 views