cx-oracle-users

[cx-oracle-users] ORA-00937: not a single-group group function

[<prz...@po...>]

Hello,

I am trying to run some sql query using cx_oracle (CentOS).
When I run this query using sqlplus I get the result.
When I try to run the same query using cx_oracle I get:
Traceback (most recent call last):
  File "./ar2-select.py", line 67, in <module>
    order by 1")
cx_Oracle.DatabaseError: ORA-00937: not a single-group group function

Can anybody tell me why is that ?

Regards
Przemyslaw Bak (przemol)
--
http://przemol.blogspot.com/



















































----------------------------------------------------------------
Najwieksza baza samochodow nowych i uzywanych
Sprawdz >> http://linkint.pl/f2a0b

Re: [cx-oracle-users] ORA-00937: not a single-group group function

[Andreas M. <and...@we...>]

Hi,

I guess there is a difference between the environment
sqlplus is running in and cx_oracle. And that is causing some
kind of implicit type conversion error.

But who knows with this little sql snippet and information.

Best regards
Andreas Mock


> -----Original Message-----
> From: prz...@po... [mailto:prz...@po...]
> Sent: Thursday, August 11, 2011 2:13 PM
> To: cx-...@li...
> Subject: [cx-oracle-users] ORA-00937: not a single-group group function
> 
> Hello,
> 
> I am trying to run some sql query using cx_oracle (CentOS).
> When I run this query using sqlplus I get the result.
> When I try to run the same query using cx_oracle I get:
> Traceback (most recent call last):
>   File "./ar2-select.py", line 67, in <module>
>     order by 1")
> cx_Oracle.DatabaseError: ORA-00937: not a single-group group function
> 
> Can anybody tell me why is that ?
> 
> Regards
> Przemyslaw Bak (przemol)
> --
> http://przemol.blogspot.com/
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> ----------------------------------------------------------------
> Najwieksza baza samochodow nowych i uzywanych
> Sprawdz >> http://linkint.pl/f2a0b
> 
> ------------------------------------------------------------------------------
> Get a FREE DOWNLOAD! and learn more about uberSVN rich system,
> user administration capabilities and model configuration. Take
> the hassle out of deploying and managing Subversion and the
> tools developers use with it.
> http://p.sf.net/sfu/wandisco-dev2dev
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

Re: [cx-oracle-users] ORA-00937: not a single-group group function

[Chris G. <chr...@to...>]

It's very likely a problem with the query you're running - nothing to do
with Python.
But you don't show the query so impossible to say.
Try running the same query in SQL*Plus


On 11 August 2011 13:13, <prz...@po...> wrote:

> Hello,
>
> I am trying to run some sql query using cx_oracle (CentOS).
> When I run this query using sqlplus I get the result.
> When I try to run the same query using cx_oracle I get:
> Traceback (most recent call last):
>  File "./ar2-select.py", line 67, in <module>
>    order by 1")
> cx_Oracle.DatabaseError: ORA-00937: not a single-group group function
>
> Can anybody tell me why is that ?
>
> Regards
> Przemyslaw Bak (przemol)
> --
> http://przemol.blogspot.com/
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> ----------------------------------------------------------------
> Najwieksza baza samochodow nowych i uzywanych
> Sprawdz >> http://linkint.pl/f2a0b
>
>
> ------------------------------------------------------------------------------
> Get a FREE DOWNLOAD! and learn more about uberSVN rich system,
> user administration capabilities and model configuration. Take
> the hassle out of deploying and managing Subversion and the
> tools developers use with it.
> http://p.sf.net/sfu/wandisco-dev2dev
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

Re: [cx-oracle-users] ORA-00937: not a single-group group function

[<prz...@po...>]

On Thu, Aug 11, 2011 at 02:13:16PM +0200, prz...@po... wrote:
> Hello,
> 
> I am trying to run some sql query using cx_oracle (CentOS).
> When I run this query using sqlplus I get the result.
> When I try to run the same query using cx_oracle I get:
> Traceback (most recent call last):
>   File "./ar2-select.py", line 67, in <module>
>     order by 1")
> cx_Oracle.DatabaseError: ORA-00937: not a single-group group function
> 
> Can anybody tell me why is that ?

Thank you for your answers: indeed I did some mistake rewriting this query into
cx_oracle - I compared it again with the original query and found a mistake.

Thanks again.

Regards
Przemek



















































----------------------------------------------------------------
Zarabiasz 4 tys./miesiac? Damy wiecej!
Sprawdz >> http://linkint.pl/f2a0f