Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> How To?: Cursors and Recursion

How To?: Cursors and Recursion

From: Alexander Pino <Alexander.Pino_at_cea-int.com>
Date: Thu, 3 Jun 2004 15:24:16 +0200
Message-ID: <40bf2681$0$48920$e4fe514c@news.xs4all.nl>


How can I declare a local cursor within a recursive function? What this function does is it clean up a hierarchy.

I know in SQL Server it is DECLARE xxx CURSOR LOCAL FOR ....

, but for Oracle I don't know it.

Could someone please help me?

Thanx,
Alexander Received on Thu Jun 03 2004 - 08:24:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US