Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Problem to access to the value of a collection

Problem to access to the value of a collection

From: slim <sfar_selim_at_excite.com>
Date: 17 May 2002 03:15:59 -0700
Message-ID: <491f65ba.0205170215.78a95805@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US