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

  • 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:FILTER> DOCUMENT_ID IN (20000001, 20000002, 20000003) GROUP BY (ACCOUNT)

    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