Oracle stored procedure in excel without VBA/macros

Question

I want to execute this below stored procedure in Excel without VBA/macro code and get output. Any idea how to get this?

create or replace 
    PROCEDURE  TEST2 (P_OUTCUR OUT SYS_REFCURSOR)

    IS

    V_ABALPH VARCHAR2(30):= 'TRYS';

    BEGIN

    OPEN P_OUTCUR FOR 

    SELECT *  FROM PRODDTA.F0101 where abalph like '%' || V_ABALPH || '%';
    commit;
    end;

excel stored proc output

Output of stored procedure should display in Excel sheet.

Here are the steps to get output in excel from SQL server.

http://datapigtechnologies.com/blog/index.php/running-a-sql-stored-procedure-from-excel-with-dynamic-parameters/

In this similar way can I do for Oracle?

I have clearly mentioned in my post and subject line that I do not wish to code in VBA. I wish to call procedure straight from excel connection properties and not VBA. by below steps datapigtechnologies.com/blog/index.php/… — Simi
– Simi, Commented Dec 2, 2016 at 16:11
I am able to do it with SQL server. Is there no way we can do with Oracle databases too? — Simi
– Simi, Commented Dec 2, 2016 at 16:14

nilsman · Accepted Answer · 2016-12-02 07:03:26Z

0

Register your DB in ODBC Sources and then use solution from datapigtechnologies.

answered Dec 2, 2016 at 7:03

nilsman

3962 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Simi Over a year ago

I am using Microsoft Oracle OLEDB connecton string............. Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=BUD;Data Source=HIBUDP1;Extended Properties=" so should I ODBC connection only then?

Collectives™ on Stack Overflow

Oracle stored procedure in excel without VBA/macros

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related