Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Problem to access to the value of a collection
Hi,
I have this type in the data base:
create or replace type t_lkz as table of number
and this is my test program
DECLARE
t t_lkz := t_lkz();
n_total NUMBER(5) := 0;
BEGIN
t.extend(2);
t(1) := 2;
t(2) := 4;
FOR cur IN ( (SELECT DISTINCT * FROM TABLE(cast(T AS T_LKZ)) ) ) LOOP
END LOOP;
dbms_out.put_line(n_total);
END; thanks for help Received on Fri May 17 2002 - 05:15:59 CDT
![]() |
![]() |