none
How is it possible a sum Group by select using wcf sql oracle adapter?

    Question

  • Dear all,

    I  need to do a Group by query to an oracle db server. 

    I reach to make simple query, but if I use a more complex query whit sum and group by I have not good results. 

    This is the message I try to send to the adapter port: 

    <ns0:Select xmlns:ns0="http://Microsoft.LobServices.OracleDB/2007/03/DBNAME/Table/INVOICES">
      <ns0:COLUMN_NAMES> ACCOUNT ,  SUM (AMOUNT)</ns0:COLUMN_NAMES>
      <ns0:FILTER> DOCUMENT_ID IN (20000001, 20000002, 20000003) GROUP BY (ACCOUNT)
    </ns0:FILTER>
    </ns0:Select>

    The result that I see in the administration console is like this:

    It will be retransmitted after the retry interval specified for this Send Port.

    Details:"Microsoft.ServiceModel.Channels.Common.TargetSystemException: ORA-00979: not a GROUP BY expression --->

    Oracle.DataAccess.Client.OracleException: ORA-00979: not a GROUP BY expression



    What's wrong?

    Thank you in Advance

    Sunday, November 8, 2015 8:03 PM

Answers