System: 8.1.6 on NT 4 w/ sp6a 6 HD PIII CPU and 1G RAM
In my procedure, I have a query to use remote database link to the data
source. I defined the query by a cursor. According to Tom and Oracle
knowledge, the FETCH … BULK COLLECT INTO won’t work with the query using
the database link. Tom suggested to define a new array datatype
something as:
create or replace type vcArray as table of varchar2(35);
/
and a query such as
select cast( multiset( select username
from all_users_at_ora8i.world
where rownum <= 10 ) as vcArray )
into l_data
from dual;
to obtain all the records at once.
My question is : because the vcArray type is an one-dimensional array
type, how can I apply such trick for querying records of multiple
columns?
I have tried without success. Do I have to write there separated CAST(
MULTISET (…) in the outer SELECT..? It does not sound right. Can any
one give a hint? Thanks.
C Chang
Received on Fri Jul 18 2003 - 21:28:21 CDT
