Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> JDBC / stored procedures / transaction/ rollback capability

JDBC / stored procedures / transaction/ rollback capability

From: CaboDog <cabodog_at_home.com>
Date: Sun, 12 Dec 1999 04:00:32 GMT
Message-ID: <A5F44.751$ds3.18574@news1.alsv1.occa.home.com>


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 Sat Dec 11 1999 - 22:00:32 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US