Information générale
Titre:
Returning Result sets as a cursor ? from Oracle
HI!
I am trying seom test but can't seem to accomplish 1 thing...
Maybe someone can help.
To set it up you need Oracle and VFP 6.0
Here is the oracle code:
create or replace package types
as
type cursortype is ref cursor;
end;
/
create or replace function sp_listemp return types.cursortype
as
l_cursor types.cursortype;
begin
open l_cursor for select recno,mainkey from modacad order by recno;
return l_cursor;
end;
/
Note replace "select recno,mainkey from modacad order by recno"
with your SQL Statement:
Executing the following SQL Plus code works as I want it to...
************
variable c refcursor
exec :c :=sp_listemp
print c
But the question is how do I call this function from foxpro....
I tried
SQlExec( h, "{call sp_listemp(?@OutParam)}" )
SQlExec( h, "{call sp_listemp()}" )
But nothing works...
At one point I got a message something like cannot return
cursor result sets or something but I can't remember what I did.
Anyone got any ideas????
Maybe I need to use ADO RS's?
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement