My Oracle Support Banner

eTL SUM and Group by fail with error: 'Can't select both scalar values and aggregate functions.' (Doc ID 1025541.1)

Last updated on OCTOBER 16, 2007

Applies to:

Oracle Java CAPS Core - Version: 5.1.1 and later
Information in this document applies to any platform.


5.1.1 eTL editor is giving the following error when using sum and group by clauses. The error complains that you can not select both scalar vlaues and aggregate functions.

Test execution failed: Invalid eTL Collaboration.

Can't select both scalar values and aggregate functions.

To verify if there is a problem in SQL, it was executed against oracle using SQL PLUS. It works fine.

SQL> select 'Department:'||dname dname, sum(sal) from emp, dept where emp.deptno=dept.deptno group by dname;

------------------------- ----------
Department:ACCOUNTING 8750
Department:RESEARCH 10875
Department:SALES 9400


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.