This content has been marked as final. Show 2 replies
I ran export for a different SQL, the .csv file was generated.
Not sure if the issue I encounter is data-related. I want to point out that some of the return data contains ASCII control characters:
This is the exact SQL for the hanged-export:
select c.email_addr,c.job_title, regexp_replace(c.job_title,'[[:cntrl:]]','#'),
from HZ_IMP_CONTACTS_T t, my_contact c
and t.REL_ORIG_SYSTEM_REFERENCE = c.pr_dept_ou_id || ':' || c.row_id
and rownum < 200
Hope you can reproduce this issue.
To reproduce, or to attempt to reproduce, we would need the data involved, not just your query.
Can you attempt to limit the rows in your query to see if you can isolate the 'bad data' that you suspect might be causing our export to break?
Also, try this as a workaround
SELECT /*csv*/ c.email_addr, c.job_title, ...
and execute with F5
If this works, you'll have your csv data come back in the Script Output window and you can copy and paste it out to your file.