single-group function and bind variables

From: Gerrit-Jan Linker <gjlinker_at_oraxcel.com>
Date: 23 May 2002 05:03:37 -0700
Message-ID: <774a64cd.0205230403.5bf2bc5e@posting.google.com>

I am using the Oracle OLEDB driver from VB and have difficulties with aggregate functions in conjunction with bind variables. Does anyone know whether this is a bug?

select sum(sal) from emp where ename = 'SCOTT'
==> OK

select sum(sal) from emp where ename = :my_ename
==> ORA-00937: not a single-group group function

Both statements are fine in SQL*Plus but fail through OLEDB. Received on Thu May 23 2002 - 07:03:37 CDT