subqueries in cursors?

From: Gerhard Moeller <Gerhard.Moeller_at_OFFIS.Uni-Oldenburg.de>
Date: 1998/01/08
Message-ID: <6931qc$hnv@news.Informatik.Uni-Oldenburg.DE>#1/1

Hi,

I just experienced that there are no subqueries allowed in PL/SQL cursors. A Cursor like

	CURSOR foo IS
	SELECT bar FROM (SELECT ...) ...

seems not allowed in PL/SQL 2.3.

Is that really true? Why? And how can I work around this elegantly?

Gerhard...

-- 
Dipl. Inform. Gerhard Möller -- Gerhard.Moeller_at_OFFIS.Uni-Oldenburg.DE
                                      ICQ PIN: 2804938
OFFIS                  | | | | | |    Tel.:    0441/9722-122
Escherweg 2            | | | | | |    Sekr.:   0441/9722-113 oder -101
D-26121 Oldenburg      |O|F|F|I|S|    Fax:     0441/9722-102

Received on Thu Jan 08 1998 - 00:00:00 CST