Ways to pass a calculated recordset from Oracle to Access
Posted on 2010-01-07
I am porting a database to Oracle (10g), while keeping an Access (2003) front-end for the time being.
Several features (searching, navigating, analysing) require a recordset to be built through code, including recursive functions for tree-traversal and data collection. I used to do this in Access with dynamic queries and ADO recordsets.
What are my options in Oracle? I can build a table in memory, but can I return that to an ADO recordset? Can functions or procedures return records? Do I need to create a temporary table and return a view on that table? Do I need to create an iterator to retrieve records one by one?
I'm basically searching for ideas, the implementation is totally open at the moment.
Markus -- (°v°)