RE: Group By nested too deep...
- From: April Wells <AWells@xxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 5 Mar 2004 10:13:49 -0600
sorry... 9.2.0.2 on AIX 5L
you will LOVE this error... ever so informative...
The query is 6 pages long
ORA-00935 group function is nested too deeply
Cause: This is an internal error message not usually issued.
Action: Contact Oracle Support Services.
April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
@>-->-->--
"Few people really enjoy the simple pleasure of flying a kite"
Adam Wells age 11
"Imagination is the highest kite one can fly."
Lauren Bacall
-----Original Message-----
From: Bobak, Mark [mailto:Mark.Bobak@xxxxxxxxxxxxxxx]
Sent: Friday, March 05, 2004 9:57 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Group By nested too deep...
April,
What version of Oracle?
What specific error?
-Mark
-----Original Message-----
From: April Wells [mailto:AWells@xxxxxxxxxx]
Sent: Friday, March 05, 2004 10:38 AM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: Group By nested too deep...
Okay, suffice it to say that I do not understand some of the business rules
that we have... HOWEVER...
I have been looking through the docs in a futile attempt to figure out the
answer to a question posed by one of our developers. It appears that we
have a business requirement that calls for a Group by to have upwards of 50
different columns IN the group by list and it is giving her an error.
I didn't know there was a limit on what you could group by (only the
resulting horrendously ugly sort that would occur). Anyone have a pointer
to doc on what those limits might be?
April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
@>-->-->--
"Few people really enjoy the simple pleasure of flying a kite"
Adam Wells age 11
"Imagination is the highest kite one can fly."
Lauren Bacall
The information contained in this communication, including attachments, is
strictly confidential and for the intended use of the addressee only; it may
also contain proprietary, price sensitive, or legally privileged
information. Notice is hereby given that any disclosure, distribution,
dissemination, use, or copying of the information by anyone other than the
intended recipient is strictly prohibited and may be illegal. If you have
received this communication in error, please notify the sender immediately
by reply e-mail, delete this communication, and destroy all copies.
Corporate Systems, Inc. has taken reasonable precautions to ensure that any
attachment to this e-mail has been swept for viruses. We specifically
disclaim all liability and will accept no responsibility for damage
sustained as a result of software viruses and advise you to carry out your
own virus checks before opening any attachment.
The information contained in this communication, including attachments, is
strictly confidential and for the intended use of the addressee only; it may
also contain proprietary, price sensitive, or legally privileged information.
Notice is hereby given that any disclosure, distribution, dissemination, use,
or copying of the information by anyone other than the intended recipient is
strictly prohibited and may be illegal. If you have received this communication
in error, please notify the sender immediately by reply e-mail, delete this
communication, and destroy all copies.
Corporate Systems, Inc. has taken reasonable precautions to ensure that any
attachment to this e-mail has been swept for viruses. We specifically disclaim
all liability and will accept no responsibility for damage sustained as a
result of software viruses and advise you to carry out your own virus checks
before opening any attachment.
Other related posts:
