Automation designer

[JohnDorlon]

Hi Jim,

See my reply here. At the bottom is a link to my dropbox folder that has some docs that should help.

Toad for Oracle Query Iterator

I'm trying to get a very basic loop working to insert some records into a table. I've worked with Toad Data Point for a number of years, but this doesn't appear to use the colon or pound sign variables the way TDP does. My problem is this. In my query iterator I have a simple select to return a list of values. Then I have a child action that is properly nested under it. In that I have an insert from select statement and I need to pass the output of the list to the insert as an input paramet…

Here's a link to the folder:

Toad

The doc: "Automation Designer: Choose which script to run based on a variable" uses a query iterator with a script.

Let me know if you still have questions.