I am querying oracle thru ssis execute sql task. When i use the
following direct input query, i am getting error message <No result
rowset is associated with the execution of this query> but when i use a
simple query it runs just fine.

here is the pl/sql code im using (returns names as comma delimited
test). Can I not use PL/SQL code in this task???

with
data as (
select name,
row_number() over (order by bsc) rn,
count(*) over () cnt
from TABLE_NAME
)
select substr(sys_connect_by_path(name,','),2) name_list
from data
where rn = cnt
connect by prior rn = rn-1
start with rn = 1

Any input/ideas/suggesstions are greatly appreciated.

Thanks.