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