SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

GROUP BY error executing a dblink querie on 11g

User607378-OracleSep 13 2012 — edited Sep 13 2012

Hi all,

I would appreciate your help.
Thanks in advance.

Best regards, Cristina.

_____________________________________________________________________________________________________________________________

Our customer is upgrading DB from 10g to 11g (11.2.0.3) and the querie that used to work on 10g does not work on 11g throwing the following error.
The querie uses a dblink to a 10g instance (ORAHIS)

SELECT to_char(DTLMCBR,'ddmmyyyy'), sum (valor_doc) FROM isbtdofi00@ORAHIS.CLI.PT (dblink to 10g) GROUP by to_char(DTLMCBR,'ddmmyyyy');

ERROR:
ORA-00979: Not a GROUP BY expression
ORA-02063: preceding ORAHIS line

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 11 2012

Added on Sep 13 2012

5 comments

1,870 views