Forum Stats

  • 3,816,042 Users
  • 2,259,133 Discussions
  • 7,893,368 Comments

Discussions

Oracle stored procedure with three parameters how to conntect to Excel

746127
746127 Member Posts: 4
edited Jan 13, 2010 5:09AM in SQL & PL/SQL
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

Answers

  • Karthick2003
    Karthick2003 Member Posts: 13,711 Bronze Badge
    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
    746127 Member Posts: 4
    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
    Karthick2003 Member Posts: 13,711 Bronze Badge
    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.
This discussion has been closed.