How to use Oracle stored procedure in Excel

[mnjogin]

Hi,

I can execute Oracle stored procedure through VBA/Macro but user is asking not to use VBA/Macro.

I am able to use Oracle table and view directly but not Oracle stored procedure

Can you please give me some suggestions how to execute Oracle stored procedure without VBA/macro in Excel?


Thanks and Regards,
Manjunath N. Jogin

[rwgrietveld]

IMHO excel gives two options:
Use Excel worksheet functionality and/or VBA

If the latter is not possible, then on WS remains.

If it's the oracle data you are after, a pivot table (external data connection) might bring you a solution. I do not see any other way.