Problem of Uncertain no. of columns

You should not take your INSERT outside instead you need to build the INSERT along with column dynamically and execute the query. That should do the trick for you.

If you can provide DDL/DML/Sample data and your proc, we will be able to help you further.