Answer the question
In order to leave comments, you need to log in
FireDac PostgreeSQL Get the result of a function that returns refCursor?
Dear professionals, please help me deal with the problem:
The PostgreSQL server itself and the function
CREATE OR REPLACE FUNCTION adqa_ref_cursors3()
RETURNS refcursor AS
$BODY$
DECLARE
ref REFCURSOR;
BEGIN
OPEN ref FOR SELECT * FROM "Customers";
RETURN ref;
END;
$BODY$
procedure TForm1.Button1Click(Sender: TObject);
begin
ADStoredProc1.FetchOptions.AutoClose := False;
ADStoredProc1.StoredProcName := 'adqa_ref_cursors3';
ADStoredProc1.Open;
end;
Answer the question
In order to leave comments, you need to log in
Try asking the component developers a question. It seems that their old forum is not dead yet www.da-soft.com/forums/anydac-osnovnoj-russkij.html
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question