This content has been marked as final. Show 2 replies
Have a look at the Developer Guide for OSB... Oracle JCA Adapter for Database is supported... Have a look at the limitations, there's nothing mentioning performance...
Also have a look at the following blogs... One of them even suggests that jca performs better than xquery with fn-bea:execute-sql...
If you are still in doubt open a SR with Oracle Support...
Hope this helps...
Thanks for your reply.
The conern more is if there is finegrained call to the DB from OSB? other wise we may need to use stored procedure to make coarsegrained.
And also to make this call to DB, some business decision need to happen which eventually will be in OSB onlly.