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;
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