PLSQL cursor limitations
From: miff <miff_at_ix.netcom.com>
Date: 1995/06/21
Message-ID: <3s9asf$f92_at_ixnews4.ix.netcom.com>#1/1
Date: 1995/06/21
Message-ID: <3s9asf$f92_at_ixnews4.ix.netcom.com>#1/1
has anyone else had trouble declaring any but the most primitive
cursors in plsql? Either I am doing something wrong, or one cannot use
parentheses or subselects in a cursor...
DECLARE
the error I got on this baby was --> " Found '(' when looking for [a
bunch of other stuff].
CURSOR C1 IS
SELECT DISTINCT A.data1, A.data2, A.data3
FROM table1 A
WHERE NOT EXISTS (SELECT * from table2 B
WHERE (A.data1 = B.data1
AND A.data2 = B.data2
AND A.data3 = B.data3) );
should I even bother using cursors?
-miff Received on Wed Jun 21 1995 - 00:00:00 CEST