Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: 8.1.7 and 9.2 pl/sql handling
RR wrote:
> Daniel Morgan wrote:
> >
> > This would work a whole lot better if you gave us some sense of what the data looks
> > like and samples from the two different result sets. Right now the only thing I can
> > think of is: You haven't got a WHERE clause so what's the point of the loop.
> >
> > --
> >
>
> Sorry, I guess I didn't make my code or intentions clear:
>
> This is code that mimics the results of what my real code does, using
> the ALL_OBJECTS view so that others could test it themselves. Why do I
> need a where clause? The point isn't to include or exlude particular
> values in this case, it is simply an analogous to my actual code, which
> returns a varchar2 value and a corresponding numeric value.
>
> If you need further clarification, please feel free to ask.
>
> Thanks!
Unless you are willing to provide something of substance ... no help is possible from my desk.
Perhaps someone else has a working crystal ball or Taro cards.
-- Daniel Morgan http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp http://www.outreach.washington.edu/extinfo/certprog/aoa/aoa_main.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Wed Aug 27 2003 - 19:54:37 CDT
![]() |
![]() |