bull collect question
Date: 11 Jun 2002 01:49:25 -0700
Message-ID: <c47cd990.0206110049.7df96ce9_at_posting.google.com>
hello,
I'm having some problems using BULK COLLECT operator with collections.
The following does not work for me:
I'm building the following dynamic cursor statement:
sql_text:='SELECT CAST(MULTISET(SELECT T1.c1, T2.c2, T3.c3
FROM TABLE1 T1, TABLE(CAST(:col AS COLLECTION1)) T2
WHERE T1.c1=T2.c1) AS COLLECTION2) FROM DUAL';
OPEN cv FOR sql_text USING c1;
and now when using
FETCH cv BULK COLLECT INTO c2;
LOOP
FETCH cv INTO c2;
EXIT WHEN cv%NOTFOUND;
END LOOP;
everything is just fine
But, when trying to use BULK COLLECT here:
I'm getting a runtime error
What can that be? The datatypes do not seem to be inconsistent, they
work with with regular FETCH INTO. Perhaps such usage of BULK COLLECT
is not permitted (why?), it's just the error message that is
confusing?
thanks in advance
ORA-00932: inconsistent datatypes