I am writing a PL/SQL procedure (Oracle) that will be called by a J2EE program. This J2EE program has started a distributed transaction and my PL/SQL procedure will be part of this transaction. I wonder if it is allowed to use a dblink inside my procedure. I guess it may cause some problems because the use of a dblink implies a distributed transaction managed by Oracle, but there is already a distributed transaction managed by the J2EE container. Is it forbidden ? or allowed with some restriction ?
Thank you for your answers.
If you are talking about XA Distributed Transactions then such configuration is supported, but with some limits (It depends on the version of your Oracle DB). For more details you can check this document Pay attention to the section "XA and Database Links"