recursive function with cursor

Posted in 1997

Michal Hajek — Thu, 18 Dec 1997 15:30:21 +0100 — source: Informix-list mailing list archive (1991-1998)

Hi, I want to use cursor in recursive function. But program stops with error -400 "Fetch attempted on unopen cursor". The same function without recursive call works good. This is tracking: (FREC is the recursive funcion) FREC (1) START OK FREC (2) START OK (recursive call) FREC (2) END OK --the error: the FREC (1) cursor was closed by FREC (2) ??? I tried WITH HOLD, and also not to free cursor - no change. How to do it ? Thanks, Michal -- -------------------------------------------------------------- Michal Hajek mailto:hajek@nspuh.cz Sprava NIS http://www.nspuh.cz NsP Uherske Hradiste phone : voice +420 0632 529 204 Purkynova 365 fax +420 0632 551 014 686 68 Uherske Hradiste Czech Republic --------------------------------------------------------------