>Thanks. I gotta get out of the VFP SQL limitation mode. I forget that subqueries are allowed in more places in Oracle than they are in VFP. These SPs that return cursors work great for me. However, my tables only have about 60,000 records in them at the most, and we have top flight servers that Oracle is running on.
What is the average result set size? I was getting okay results returning small (<100 rows) result sets. However, when I returned 4000+ rows (Admin function that listed everything), the performance went into the sewer (13+ seconds).
BTW, the same query that took 13+ seconds using the Oracle ODBC driver took 1.6 seconds using the MS ODBC Driver for Oracle using that technique.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao