I'm creating a VFP application that reports on data from an Oracle Database at a remote location. The required information comes from several relational tables. My initial select results in a cursor of about 1500 rows. By creating paramatarized views - scanning the cursor and issuing requery(), I can assemble the information I need. What I really want to do is 'leave' the initial cursor on the server and perform subsequent queries using that cursor - only fetching the final result set. In most instances I need to perform outer joins because data may or not be present in the supporting tables. My initial select already requires an outer join - my understanding is that only one outer join is allowed per select under Oracle.

This seems like a routine requirement and should be obvious - but I haven't had any luck finding out how to do it.