Couldn't you call it just as a procedure? Larry
On Fri, Aug 28, 2009 at 9:02 AM, Clinton Begin<clinton.be...@gmail.com> wrote: > I don't, but that's pretty awesome that you figured that out and it works... > LOL. :-) > > Clinton > > On Fri, Aug 28, 2009 at 8:56 AM, Beary, Nick (EHQ) > <nbe...@express-scripts.com> wrote: >> >> Hello, I looked around for an answer to this but didn’t see anything. To >> insert objects in our database, I have to use a macro that returns the key >> of the newly inserted object. This means that the entirety of my insert >> statement is located in the selectKey section. Because an SQL statement is >> required in the PCDATA section outside of <selectKey>, I just put a ; >> there. So it looks like this: >> >> <insert id="insert-xxx" parameterClass="xxx"> >> ; >> <selectKey resultClass="int" keyProperty="ID"> >> exec insert_macro(…) >> </selectKey> >> </insert> >> >> Does anybody know a more elegant/less hacky solution to this? >> >> We are using Teradata 12.0. >> >> Thanks! >> Nick >> >> >> > --------------------------------------------------------------------- To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org
