Hmm. It's been years since I've worked with VFP and Oracle. But there must be a mechanism in PL/SQL to return a result set. There has to be, otherwise Oracle would not work too well with front-ends.
>Oracle does not return any thing from a procedure unless it is passed by reference. It is therefore impossible for a cursor to be returned from a stored procedure. SQL pass through of a select statement doesn’t call a stored proc so it will return a cursor.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05