Problems with Get_List_Element_Count

From: Jocke <jocke_at_abb.se>
Date: 1997/11/26
Message-ID: <65gl34$104g_at_sdaw04.seinf.abb.se>#1/1


Hi

My problem are as follows:

I want to populate a list from a query and then add some extra elements to the list. I've been trying with the following code:

PROCEDURE fill_list(item_name in varchar2) is

  rg_id_cvp RecordGroup;   list_id_cvp Item := Find_item(item_name);

  errcode      NUMBER;              
  cnt          NUMBER(2);                 

BEGIN
  rg_id_cvp := Create_group_from_query('my_new_group',

       'select cc_name, to_char(id) from cc_names');   errcode := Populate_group(rg_id_cvp );   Populate_list(list_id_cvp, rg_id_cvp);

[Quoted]   cnt := Get_List_Element_Count(list_id_cvp);

  Add_List_Element(list_id_cvp, cnt + 1, 'Extra 1', '1');   Add_List_Element(list_id_cvp, cnt + 2, 'Extra 2', '2'); END; [Quoted] But I end up with the following error

ORA-06502: PL/SQL: numeric or value error (it's the call to Get_List_Element_Count that causes the error)

How can I get this to work ?

/Jocke Received on Wed Nov 26 1997 - 00:00:00 CET

Original text of this message