Insert statement returns generated key

[Beary, Nick (EHQ)]

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