cursor/TOraStoredProc

[hip]

Hello,

I use cursor in a TOraStoredProc

Code: Select all

--Oracle 9i
PROCEDURE REQ_DPTEST(C OUT SYS_REFCURSOR) IS
BEGIN
OPEN C FOR
SELECT *
FROM DPTEST;
END;

in a TOraStoredProc (PROC_TEST)

and I do that in DELPHI (Code Gear Rad Studio 2007)

Code: Select all

with PROC_TEST do
begin
Execute;
   try
      while not EOF do
      [...]
      FieldByName('COL_TEST1')...
      FieldByName('COL_TEST2')...
      [...]
      Next
      end
   finally
   Close--
   end
end;

It works. But it is the good way? Can i have problems with "too many open cursors"?

Hip

[bork]

Hello

We have never heard about any issues with OUT SYS_REFCURSOR parameters.

[hip]

thx