# Export Dataset with Parameter from List Iterator

**URL:** <https://forums.toadworld.com/t/export-dataset-with-parameter-from-list-iterator/39035>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [February 3, 2017, 2:32pm UTC](https://forums.toadworld.com/t/export-dataset-with-parameter-from-list-iterator/39035 "2017-02-03T14:32:26Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![ralf.wewstaedt2013](https://avatars.discourse-cdn.com/v4/letter/r/4da419/32.png) [@ralf.wewstaedt2013](https://forums.toadworld.com/u/ralf.wewstaedt2013)\
**Post date:** [February 3, 2017, 2:32pm UTC](https://forums.toadworld.com/t/export-dataset-with-parameter-from-list-iterator/39035/1 "2017-02-03T14:32:26Z")

</div>

Hello,

I tried to export dataset like

select :NAMEN as UEBER from dual

I used “set variables” and bind :NAMEN with the List Iterator NAMEN (two entries : NAME1,NAME2).

I am export this as an excel file and the output is:

**UEBER**  
%NAMEN%  
I would expect NAME1 (for the first iteration) … where is my fault ?

greets

Ralf

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [February 7, 2017, 2:02pm UTC](https://forums.toadworld.com/t/export-dataset-with-parameter-from-list-iterator/39035/2 "2017-02-07T14:02:29Z")

</div>

1. in the list interator, use single quotes around each value

2. make your select like this: Select &NAMEN as EUBER from dual

3. in the “Set Variables” dialog, choose “Environment Variables” and then then name of your list iterator.

---

<div class="post-metadata">

**Author:** ![amit\_naidu](https://avatars.discourse-cdn.com/v4/letter/a/7ea924/32.png) [@amit\_naidu](https://forums.toadworld.com/u/amit_naidu)\
**Post date:** [February 23, 2018, 9:00pm UTC](https://forums.toadworld.com/t/export-dataset-with-parameter-from-list-iterator/39035/3 "2018-02-23T21:00:15Z")

</div>

Select \* from &MySchema…&My\_tables\_list\_iterator;

Toad For Oracle 12.10.0.30

I have the same issue and no resolution after 2 hours of searches and trial and error.

The Set Variables dialog in the Export Dataset action does not show List Iterator variables in the Environment Variables list.

The &MySchema in my query is a global toad variable, so that works fine. But the table names that I want to loop over should come from the parent List Iterator, but that iterator variable is not recognized at all.

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [February 26, 2018, 6:28am UTC](https://forums.toadworld.com/t/export-dataset-with-parameter-from-list-iterator/39035/4 "2018-02-26T06:28:16Z")

</div>

This works in Toad 12.12. Unfortunately, it does not work in 12.10. "List Iterator 1" doesn't show up among the environment variables in the 2nd screenshot in 12.10.

 ![Step1.jpeg](https://global.discourse-cdn.com/quest/original/2X/5/5478f291cba435bc8eec3da44dbf5a4df7ada460.jpeg)

 ![Step2.jpeg](https://global.discourse-cdn.com/quest/original/2X/a/ac86aab1ed512a1c5243033fc555547f75517a08.jpeg)

 ![Step3.jpeg](https://global.discourse-cdn.com/quest/original/2X/5/54c456a4216a2096becedb3f6a55c46ed151bed3.jpeg)

Then run it by right-clicking on the List Iterator action and choosing "Run". Toad creates c:\EMP.txt and c:\DEPT.txt.

---

<div class="post-metadata">

**Author:** ![amit\_naidu](https://avatars.discourse-cdn.com/v4/letter/a/7ea924/32.png) [@amit\_naidu](https://forums.toadworld.com/u/amit_naidu)\
**Post date:** [February 26, 2018, 9:57am UTC](https://forums.toadworld.com/t/export-dataset-with-parameter-from-list-iterator/39035/5 "2018-02-26T09:57:11Z")

</div>

What can I do to workaround this in 12.10 ?

Is there no way to iterate over Export Dataset action at all ?

Is there any way to set an environment variable to the result of a query or another variable ? Or even just i = i + 1 ?

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [February 26, 2018, 10:03am UTC](https://forums.toadworld.com/t/export-dataset-with-parameter-from-list-iterator/39035/6 "2018-02-26T10:03:22Z")

</div>

There’s no way to use a list iterator with export dataset in 12.10. You can export multiple tables/views like this:

1. go an Export Dataset action on automation designer. Double-click it to open the Export Dataset window.

2. click on “dataset” tab and choose “Export objects”

3. click “Add” to add the objects that you want to export.