Re: very long sqlplus query with implicit view

Thanks Michael!

But the problem is, my grouping is only on 2-3 fields, nothing major that stopped anything else. I'm wondering if some humongous decodes in the select statement is what's doing it, since it is performing a calculation and selecting from a range on the fly. (The statement takes up 11 lines, and is repeated 3 times - I think by using a view ahead of time I can get rid of all this and only do it once. Which is probably the right way to go anyway, but any insight on this would be appreciated.)

John

In article <826h38$nhe$1_at_nnrp1.deja.com>,   michael_bialik_at_my-deja.com wrote:
> Hi.
>
> Usually you have that error when the total length of sort fields (
> mentioned in GROUP BY, ORDER BT, etc ) exceeds the db block size.
> Try to rewrite you query avoiding sort.
>
> HTH. Michael.
>
> In article <826avb$ing$1_at_nnrp1.deja.com>,
> Screamin' Johnny <jrehg_at_yahoo.com> wrote:
> > Hi!
> >
> > I am trying to generate a sqlplus report using an implicit view in
my
> > from clause and keep getting an error message:
> > sort key too long and error # ora 01467
> > for which I can find no documentation.
> >
> > I am thinking of creating some temporary views and was wondering if
> > this would resolve the problem.
> >
> > Any help would be greatly appreciated!
> >
> > --
> > Thanks,
> > The Wild Man
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

--
Thanks,
The Wild Man

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Dec 06 1999 - 08:13:24 CST