Oracle function or package to execute SQL and return records

I need to call a package or function from Excel and cause the processing to be done on the server rather than on the local machine. To do this I need to pass a SELECT SQL statement to a package or function and it will return the record set.

The reason for this is that we have 100s of SQL statements that are currently processed in Excel but due to VPN slowness they are taking much longer. I have tried a single package to run an SQL when called and it is significantly quicker. Any approach to pass only SELECT SQL statements to a function and just return the records will be a great help.

Oracle version 11.

Continue reading...