Oracle stored procedure with three parameters how to conntect to Excel

746127

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

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.