Path: text.usenetserver.com!out02b.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!o38g2000hse.googlegroups.com!not-for-mail
From:  "amerar@iwc.net" <amerar@iwc.net>
Newsgroups: comp.databases.oracle.server
Subject: Re: Help trying to debug this DUMB pl/sql code
Date: Mon, 05 Nov 2007 11:48:48 -0800
Organization: http://groups.google.com
Lines: 58
Message-ID: <1194292128.410310.86240@o38g2000hse.googlegroups.com>
References: <1194286415.300557.290910@19g2000hsx.googlegroups.com>
   <1194286765.478294.184270@d55g2000hsg.googlegroups.com>
   <1194289465.811099.98490@22g2000hsm.googlegroups.com>
   <1194291313.440891.104910@v29g2000prd.googlegroups.com>
NNTP-Posting-Host: 208.65.116.5
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
X-Trace: posting.google.com 1194292128 21661 127.0.0.1 (5 Nov 2007 19:48:48 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 5 Nov 2007 19:48:48 +0000 (UTC)
In-Reply-To: <1194291313.440891.104910@v29g2000prd.googlegroups.com>
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.8) Gecko/20071008 Firefox/2.0.0.8,gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: o38g2000hse.googlegroups.com; posting-host=208.65.116.5;
   posting-account=ps2QrAMAAAA6_jCuRt2JEIpn5Otqf_w0
Xref: usenetserver.com comp.databases.oracle.server:437322
X-Received-Date: Mon, 05 Nov 2007 14:48:48 EST (text.usenetserver.com)

On Nov 5, 1:35 pm, gerryt <lepsys...@gmail.com> wrote:
> On Nov 5, 11:04 am, "fitzjarr...@cox.net" <fitzjarr...@cox.net> wrote:
>
>
>
> > On Nov 5, 12:19 pm, "ame...@iwc.net" <ame...@iwc.net> wrote:
>
> > > On Nov 5, 12:13 pm, "ame...@iwc.net" <ame...@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.......