I have Toad for Oracle 10.6.1.3.
I created a “List Iterator” in Automation Designer and inside I created an “Export Dataset” with an Export query. In this Export query I need to use the variable %List Iterator% (Sample: select %List Iterator% from Dual ) but I get the error “ORA-00911: invalid character”.
My question is: How can I use the variable %List Iterator% in my Export query?
Is somebody can help?
ToadVarListIterator.docx (173 KB)