quote:
Is the SQL built dynamically?
I miss spoke above. In addition to passing the procedure dynamic global temp table names, I am also passing it various parameters for WHERE clauses.
I replaced the dynamic global temp tables with static temp tables. did not help.