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.

Symptoms

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;

DNAME SUM(SAL)
------------------------- ----------
Department:ACCOUNTING 8750
Department:RESEARCH 10875
Department:SALES 9400
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms