Tim,
I try it with no luck. It's ok for calling stored procedure, but how can we get the result set from Oracle?

With visigenic, I used to use package like this:

create or replace package GLPACK3 is

-- Public type declarations
type resultset is ref cursor;

-- Public function and procedure declarations
procedure coba(rpt out resultset);
end glpack3;

create or replace package body GLPACK3 is
procedure coba(rpt out resultset) is
begin
open rpt for
select * from mtcompany;
end;

end glpack3;



From VFP 6, then I call it like this:

ltemp = ''
csql = "{call glpack3.coba(?ltemp)}"
lnerror = sqlexec(lh,csql)


I'll get the result in the form of VFP's cursor.


I can't use it with MS ODBC.

Do you have solution?

Regards,
Gunawan S.