Query works with Oracle 10g but not with 11g?
This works without errors:
DECLARE trn VARCHAR2(2) := 'DD'; cur SYS_REFCURSOR;BEGIN OPEN cur FOR SELECT TRUNC(some_date, dtrn), NULL AS dummy_2, COUNT( DISTINCT dummy_1 ) FROM (SELECT SYSDATE AS some_date, ROWNUM AS dummy_1 FROM dual) data1, (SELECT trn AS dtrn FROM dual) data2 GROUP BY TRUNC(some_date, dtrn);END;
Problem is with trn
variable and variable using in TRUNC
function. Maybe it is bug.