1 No difference in calling Oracle view or table from VFP
for example
gdid=goods.id
sqlexec(hconn, 'select * from myschema.myview where gd_id=?gdid','mycursor')
2 Oracle procedure does not return cursor to vfp, only variable
make empty value in VFP for variable before calling procedure
put this variable to oracle procedure by reference like @myvar
for example
m.var='first value'
sqlexec(hconn,' begin demo.procname(?@var) ; end ;')
?var

This code will make cursor from variable
sqlexec(hconn,'declare vr=?m.var begin demo.procname(vr) ; end ; select vr from dual ;','mycurs')


Use Oracle packets instead, it can return cursor to vfp
Oracle packet can have procedure inside it
Calling Oracle function returns cursor
Sqlexec(hconn,'select demo.func(1) as rtval from dual','mycurs')