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: 8.1.7 and 9.2 pl/sql handling

Re: 8.1.7 and 9.2 pl/sql handling

From: RR <rickraster*_at_hotmail.com>
Date: Wed, 27 Aug 2003 19:39:52 GMT
Message-ID: <3F4D0B4C.7A8F7065@hotmail.com>


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

Original text of this message

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