Problems with Get_List_Element_Count
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
