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