amerar_at_iwc.net wrote:
> On Nov 5, 1:35 pm, gerryt <lepsys..._at_gmail.com> wrote:
>> On Nov 5, 11:04 am, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
>>
>>
>>
>>> On Nov 5, 12:19 pm, "ame..._at_iwc.net" <ame..._at_iwc.net> wrote:
>>>> 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???
>> Thinking of plonking another toadie, yes : >
>>
>>>> Can I add, that I am explicitly assigning values to each of the
>>>> elements.......- Hide quoted text -
>>>> - Show quoted text -
>>> Can we add that you regularly pull this stunt (not providing any
>>> useful information, such as Oracle version [all four numbers], actual
>>> code, actual error message) and expect someone to possess a crystal
>>> ball to assist you?
>>> Can YOU add the missing information?
>> As he's been posting here since 2002 and still doesnt get it I think
>> you are
>> being optimistic : >
>
>
> I think your parents abused you both as children.......
What you think may be important to you. What I know is that I've
kill-filed you and you will no longer receive any help from me.
I think everyone else, based on your abusive attitude, should also
consider making your an internet orphan.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Mon Nov 05 2007 - 20:48:46 CST
