Re: order by not consistent

"bgt0990" <btighe_at_neometrics.com> wrote in message news:3d405a91_3_at_corp-goliath.newsgroups.com...
> Well, that's what I get for showing the easiest example of the more than
30
> of these procedures. I agree with you of course that the method you use
is
> more efficient. I realize vsort is a dead variable, in 24 other
procedures
> it's used. This form is overkill for this query but actually works quite
> well when the cursors run 3 deep and the bind variables are in the double
> digits. This code sits in the middle between a delphi user interface and
a
> crystal report output, having crystal beat on your production tables is a
> bad thing performance wise.
>
> Thanks for the response, I'ld still like to know about the order by
problem
> :(
> Barry

Sybrand and Andrew have pointed out that you'll need the order by clause on your select for your report. I'd just add that you don't need the order by on the insert (it is completely pointless).

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************