I got stuck with this stored precedure with signature on Oracle DB.
on WM 6.5, I created the adapter services but am not able to provide input to the custom SQL types. I tried converting them to String types and giving input in string format, like
new UserDataType('xxxx','asasdsds','4rtrtr', 'sdssds','CI/2356', new RoleArray(new RoleDataType('PricePlaner')), new maptype(new mapitemtype('location','Fe')))
But it did not work. I found that Software AG is not supporting this yet (link).
Is there anything that I missed out in the implementation? If you used this SP with signature then please share how I can do it too.