I\'m working on Java application that integrates with legacy system written Orac

Question

I'm working on Java application that integrates with legacy system written Oracle PL/SQL. Unfortunately i'm not able to change this legacy system. Problem with this system is that it that sometimes COMMIT statements are written into procedures. But this causes that I'm not able to handle transactions correctly on my application level.

So is it possible to make oracle database procedures to ignore commit statements?

I have found that when doing ALTER SESSION DISABLE COMMIT IN PROCEDURE in beginning of connection will cause exception when PL/SQL procedure is trying to commit. But is it possible to make Oracle to ignore commit without changing PL/SQL code?

Explanation / Answer

The answer is probably "no, it can't be done". But I have a feeling there may be some weird way to make Oracle ignore COMMITs.

You'll have to add a parameter to those procedures like"do commit"with a default value true. And you call them with parameter set to false. Pass the parameter value on, if they are nested. That way the legacy code still behaves the same but you get transaction control.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects