Re: Problems with Get_List_Element_Count

>cnt NUMBER(2);
> cnt := Get_List_Element_Count(list_id_cvp);
 

>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)
>
>

The manual says that Get_List_Element_Count returns CHAR, yet the example is just like what you are doing.

Try cnt := to_number(Get_List_Element_Count(list_id_cvp));

John Received on Wed Nov 26 1997 - 00:00:00 CET