ORA-937 when using parameters

From: aubar (laurent.kummer_at_facto.fr)
Date: 11/17/03 

Date: 17 Nov 2003 05:49:56 -0700

Hello
I'm working with D7 & Oracle 9.2

When using an ADOQuery with the SQL :
"SELECT SUM(HOUR) FROM rep.data WHERE code=:pcod"
and setting the parameter "pcod" to, let's say, 100 i get the error ORA-00937 : not a single-group group function

If i set the SQL code to :
"SELECT SUM(HOUR) FROM rep.data WHERE code=100" I have no problems.

Anyone can help ?

Thanks

Relevant Pages

  • Re: Limit of 1050 columns for ANSI joins
    ... comprehensive than Oracle SQL. ... I'm trying not to have any auto-generated SQL on my system, ... Index your schema properly and think about the proper design. ...
    (comp.databases.oracle.server)
  • Re: I cant find a SETUP.EXE in the SQL Plus Client ??
    ... someone else's server for testing some SELECT statements I'm ... free client because I don't own the Oracle license. ... SQL statements. ... There is no documentation with that download. ...
    (comp.databases.oracle.tools)
  • Re: How to convince my customer to use SQL2005 instaed of Oracle10g
    ... the old Sql versus Oracle debate. ... If I were you I would focus one SQL Server 2005 clearest advantages ... You mentioned Availability, so I assume your looking into HA (high ...
    (microsoft.public.sqlserver)
  • Re: How to convince my customer to use SQL2005 instaed of Oracle10g
    ... migration to Sql 2005 would be direct & straight forward, quick, and ... If I were you I would focus one SQL Server 2005 clearest advantages ... would need a 4 processor license but for Oracle you would need a 16 ... You mentioned Availability, so I assume your looking into HA (high ...
    (microsoft.public.sqlserver)
  • Re: SQL Server 2005 vs Oracle
    ... SQL and Oracle. ... SQL Server one sizes log files to handle the largest transaction and its ...
    (comp.databases.ms-sqlserver)