On Nov 5, 12:13 pm, "ame..._at_iwc.net" <ame..._at_iwc.net> wrote:
> Hi,
>
> I have a package I'm trying to run through a debugger and find some
> weird error. The package uses a defined type VARRAY:
>
> TYPE IN_STR_ARR IS VARRAY(500) OF VARCHAR2(500);
>
> The package has a number of parameters it accepts:
>
> PROCEDURE awi_report_php (
> p_site_id NUMBER,
> p_i IN OUT IN_STR_ARR,
> p_o IN OUT IN_STR_ARR,
> p_v IN OUT IN_STR_ARR,
> p_columns IN OUT IN_STR_ARR,
> line OUT TEST_CURSOR,
> p_str OUT VARCHAR2,
> p_save_out OUT VARCHAR2,
> p_save_in VARCHAR2 DEFAULT NULL,
> p_comp_id VARCHAR2 DEFAULT NULL,
> p_customer_id VARCHAR2 DEFAULT NULL);
>
> Anyhow, if I try to debug with TOAD, I get some error about it not
> being able to find the TYPE.
> If I try to debug using SQL Developer, it complains about some 6531
> error regarding an uninitialized collection.
>
> WTF? This thing runs without any debugger (though it has an
> error).
>
> Can anyone think of anything???
>
> Thanks!
Can I add, that I am explicitly assigning values to each of the
elements.......
Received on Mon Nov 05 2007 - 12:19:25 CST
