omg... thanks!
maybe nexttime i see it on my own :-D
Sorry about leading you astray with the examples. Hopefully next time we won't have one that is misleading.
I should mention that based upon your vdb.xml there is an unused translator override:
<translator name="translator-oracle" type="oracle">
<property name="SupportsNativeQueries" value="true" />
</translator>
It will actually cause an error if used with the multisource add column feature. This has been addressed with [TEIID-3339] Adding the multisource column does not work with variadic procedures - JBoss Issue Tracker