An INSERT EXEC statement cannot be nested

[rdharmar]

I'm trying to get the output values of a stored procedure into a table as below

Insert #temptable
Exec Stored_proc @param1, @parm2

I thought that this was possible but I get this error message.

"An INSERT EXEC statement cannot be nested."

Is this possible at all?

 

[rt63]

INSERT <table>
EXECUTE <proc>

is very much allowed. I think the problem is somewhere else. Do u have #temptable inside the proc also? Some such thing which may be causing a nesting issue?

RT

 

[rdharmar]

Thanks! You are right. I am using cursors and temp tables inside the stored proc and I too think the problem lies here. Thanks for your help.