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
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! Received on Wed Aug 27 2003 - 14:39:52 CDT
![]() |
![]() |