does that means that this will not work:

procedure query(resultset in out emp_dname_ref) is
begin
open resultset for
select e.empno, e.job, e.hiredate, e.deptno, d.dname
from emp e, dept d
where e.deptno = d.deptno;
end;

Have you try this?

Mark Oliva


>Please let me know if there is a solution. I have been searching
>for a way to return a cursor from an Oracle SP with no luck...
>
>>>As far as I understand, Oracle stored procedures cannot return result sets; the most approximate solution is to make them fill data in a cursor defined in a package (from Oracle Migration Companion)
>>You might want to check with Mike Emmons of Gargoyletech.com.. he worte this article about VFP and Oracle... http://gargoyletech.com/oracle_article.htm I don't see anything about SP's in it, but he may be able to help you.
>>
>>BOb