Hi Dan,

>It seems to me that you are trying to shoehorn something into stored

procedures that they aren't designed to do. If you are running embedded in
deployment,

>why would you even bother playing with these dynamic stored procedures

(especially since you are obviously creating each stored procedure in your
application

>code as you need it)? Is there some reason that you wouldn't simply

implement the business logic in your code and issue the SQL calls from your
code instead

>of compiling a stored procedure to do it all for you? Everything you have

been describing simply smells far too complicated to me: were I you, I would
back

>off, re-examine my initial assumptions, and see if there isn't a simpler

way.

Actually I do agree with what you are saying - we could eliminate the stored
procedures at some loss of efficency. But I would say that I have not really
gone into so much details as to how/why we ended up taking this approach.

Even if we where to adopt a different approach here - it would still be
helpfull to understand how stored procedure can be safley created and used
on a database with DML operations occuring also. If this is simply not
possible then this is fair enough.

Thanks
Ryan