Re: Recursive Cursors

#1

dammad (AT) mighty (DOT) co.za (DammaD) wrote in message

Quote:

..... I have a list
of items with children who have childern, etc, to a variable length,
and I need a tree structure to be displayed. Using a cursor I get a
list of top level items, then going through each record, I check for
children for that item, and if a child exists, I call the sp, and the
process continues.
You can use recursive query rather than recursive sp or cursor.

Many DBMS support recursive query. For example, DB2 UDB support it
with common table expression(after WITH keyword), Oracle support it
with CONNECT BY clause, etc.

#2

DammaD wrote:

Quote:

Hi all

Is there anyway to use a cursor in a sp that gets called recursivly?
If I create a sp that calls itself and it has a cursor in it, it
displays the error, "cursor already exists".(obviously) I have a list
of items with children who have childern, etc, to a variable length,
and I need a tree structure to be displayed. Using a cursor I get a
list of top level items, then going through each record, I check for
children for that item, and if a child exists, I call the sp, and the
process continues. But of course it declares a cursor with the same
name in the sp and it gives error. I don't know how many cursors I
will need so it must be dynamic. So I thought I'd just pitch it to you
guys, as I think it is impossible.

Depends on your DBMS. IBM/Informix IDS allows it.

--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler (AT) earthlink (DOT) net, jleffler (AT) us (DOT) ibm.com
Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Recursive Cursors

comp.databases comp.databases

Re: Recursive Cursors - 07-23-2003 , 08:34 AM

Re: Recursive Cursors - 07-26-2003 , 01:41 AM