I've tracked down the problem to the variable Vorgid inside the insert into statement.  This is a variable that I have declared at the beginning of the procedure and I am using a select statement to set it's value.  So the question is what is the correct way to use this variable with the Insert statement.