(Using Oracle 11.2) I have a rather complicated SQL with something like wm_concat( distinct abc ) that is expected to return some varchar2(4000) compatible result. It causes ORA-00932: incons...

I'm using oracle 11 (not sure about the exact version, but since LISTAGG doesn't work, I suppose it's not release 2) through ODBC and crystal reports 2008. Here is the problem I have: Here's a ...

I have this query : (SELECT OBJECT_ID from cr_object_group_entries_vw where object_group_id IN (SELECT ITEM FROM TABLE(CR_FN_SPLIT_STRING('28,56',',')))) that returns : But when I do : SELE...