Thanks for the question, Adriano Ferreira.
Asked: October 26, 2016 - 8:42 am UTC
Last updated: October 26, 2016 - 9:28 am UTC
Version: Oracle SOA Suite
Viewed 1000+ times
You Asked
Hello,
I'm working on a SOA project and we're using stored procedures to work with Oracle RAC in OSB.
This keep the project clean, organized, avoiding XA and others benefits. The only bad thing is a little extra time to work with.
We decided to use this approach because we have a lot of concerns about transactions (to avoid XA), and to achieve better performance, keep code centralized and other benefits.
However I've seen that the market on general, at least in Brazil, doesn't adopt this approach just to keep rapid development and many projects has problems because of wrong implementations o using XA and others.
Thus bring me to one million dollar question: It is a bad practice adopt the use of packages with storedprocedures/functions a bad practice?
Thanks for advance.
Best Regards.
and Chris said...
Is this answer out of date? If it is, please let us know via a Comment