Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Help trying to debug this DUMB pl/sql code

Re: Help trying to debug this DUMB pl/sql code

From: Shakespeare <whatsin_at_xs4all.nl>
Date: Mon, 5 Nov 2007 21:06:36 +0100
Message-ID: <472f77e7$0$230$e4fe514c@news.xs4all.nl>

<amerar_at_iwc.net> schreef in bericht
news:1194292128.410310.86240_at_o38g2000hse.googlegroups.com...

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

Well that's a way to expect any anwers from now on..... but ok, Ihave one: your version of Toad debugger does not support VARRAYS.

Shakespeare Received on Mon Nov 05 2007 - 14:06:36 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US