Trying to dynamicly build Oracle scripts, that will be run by someone else, later. The query that builds the input variable works and returns 125 rows, of latest input. But, while looping, only the very first variable is used, over and over for 125 times. For the output, only the very first variable is installed in the output. What am I doing wrong?
All_VC_ViewsTEST_20111201a.log (129 KB)
VC_2R2011-12-01 14-43-55.txt (67 Bytes)
VC_2R2011-12-01 16-47-38.txt (67 Bytes)
VC_SQL.sql (105 Bytes)
VC_TemplateR.txt (72 Bytes)
VC_TemplateTEST.txp (1.25 KB)
VC_TemplateTESTb.txp (1.35 KB)