JDBC / stored procedures / transaction/ rollback capability

From: CaboDog <cabodog_at_home.com>
Date: 1999/12/12
Message-ID: <A5F44.751$ds3.18574_at_news1.alsv1.occa.home.com>#1/1


From my Java program, I want to call stored procedures on an Oracle database that perform inserts to tables. If I call more than one of these stored procedures in succession (using JDBC callable statements) inside a transaction wrapper (in other words, I execute 2 or more of these insert stored procedures before committing) across the same connection in my Java program, if I issue a rollback, will everything that those stored procedures have done be rolled back, or is the only possible thing that can be rolled back in JDBC dynamic sql?

Brad Received on Sun Dec 12 1999 - 00:00:00 CET

Original text of this message