Using PL/SQL code in Excel Macro

[cherrykolli]

Dear All,

Can some one please tell me if i can execute a PL/SQL code with in the Microsoft excel macro. If so one example post would greatly be appreciated.

I have had success in writing the SQL in the macros by establiishing the ODBC connection. The output successfully generated and displayed on the destined sheet of the excel.

Now because of the complexity of the requirement, i had to go for the PL SQL.

Thanks.

[amitpatel66]

Logic would be to Create a PLSQL procedure in oracle database. Try connecting to Oracle database from Excel macro using ODBC connection and invoke that procedure and grab the results.