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 parameter.
I am using the syntax the query iterator shows %loopname.column%. However, the sql statement will err out if I don't put quotes around the value because it's a varchar value. The loop runs, but nothing executes properly and there's no log data to show what the rendered query looks like. I suspect the rendered variable isn't a valid value and so the select portion of the insert is returning no values.
I tried single quotes, double quotes, prompted bind vars (e.g. &1), pound signs and colons, but nothing works. I also don't see an obvious way to use a file and set the parameter on that file. When I try to use a sql file rather than the text option and add a parameter it treats the parameter as if it's another file and it doesn't appear to recognize what is in the file. For something this basic it seems to be more complicated than it should be.
I've read over several sources of Toad documentation and nothing clearly explains this. Found no videos either. Is there a correct procedure to use the query iterator to execute another query?