Re: Execute Immediate with variable qty bind params

Frank,

Thanks for your resonse.

1. Good point - I didn't attempt to insert and catch the exception as part of normal flow-control because I read somewhere that it should be avoided to mix exception handling in procedural flow. Another message group responder made the same suggestion as you though, so I am clearly approaching it the wrong way.
2. I like the idea of using a trigger, but I wondered how I would obtain the new id if the pre-insert trigger set the surrogate id. I see you suggest using "returning" as part of the insert. I'm assuming that will work, even with the trigger generating the id. I'll try it out.
3. You're right - I am using the wrong model here.
4. Didn't know EXEC IMM doesn't scale well. First time I am using it. The procedure doesn't always have all necessary data to update... so I wanted to be able to only update certain columns, indicated by which procedure parameters are not null.
5. I will re-raise the named exceptions where appropriate. Thanks for the suggestion.

-Frank Received on Sun May 14 2006 - 15:39:14 CDT