Amol
If not a stored procedure, certainly and Oracle table should be available
via OLEDB. If you go in Excel to Import External DataImport data... and
select New Data Source... Select Other AdvancedOLEDB Oracle Database and
then trip through the wizard. I don't have Oracle so can't get past first
wizard screen to see if it accepts SPs but that should get you on your way.
You can save the connection strings as a file too.
I use SQL here
http://www.nickhodge.co.uk/gui/datam...rtexternal.htm
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk
"Amol" wrote in message
ps.com...
Hi
I want to call an Oracle DB procedure using Excel. Also, the procedure
puts the processed results in a table. I want to have a report based on
this data( Simple SELECT on the table).
Is it possible?
Thanks in advance
-Amol