Toad World® Forums

How to use the "List Iterator" variable in the SQL of "Export Dataset"

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?

Thanks,

Daniel

ToadVarListIterator.docx (173 KB)

.

Hello,
Thank you for posting your question.

Can you please join our Yahoo group for help from our Developers and other Toad for Oracle users? We are able to respond much more quickly there:

http://tech.groups.yahoo.com/group/toad/

Thank you. :slight_smile: