Skip to Main Content

SQL & PL/SQL

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!

Oracle stored procedure with three parameters how to conntect to Excel

746127Jan 13 2010 — edited Jan 13 2010
I have an Oracle stored procedure and it has three parameters. I am in confusion to enable this porcedure to Microsoft Excel?

Once data are available in Excel, user will make a chart(graph).

Can you please give me some samples of code:

Stored procedure with parameters, how to connect stored procedure to Excel, Parameter pop in excel, To make working

Thanks and regards, Manjunath N. Jogin

Comments

Karthick2003
Here is a nice artical on asktom.com on how to connect oracel to excel through ODBC

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:4406709207206#18830681837358
746127
Hi Karthick,

Thanks for your suggestion.

Now I am able to use table and view in excel but I am unable to use an Oracle procedure which has three parameters.

How to achieve this please give me some sample of code.


And also how to execute Oracle stored procedure with parameters at Microsoft Query in Excel.


Thanks and regards,
Manjunath N. Jogin
Karthick2003
And also how to execute Oracle stored procedure with parameters at Microsoft Query in Excel.
No idea. Never done that before. May be try google.
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 10 2010
Added on Jan 13 2010
3 comments
627 views