Re: Savepoint in OCI

From: Scott Urman <surman_at_dlsun338.us.oracle.com>
Date: 1996/09/03
Message-ID: <50i23t$eps_at_inet-nntp-gw-1.us.oracle.com>#1/1

In article <50921e$qa7_at_infocom.kharkov.ua>, san_at_itl.net.ua (San Sanoff) writes:
|> Hi All!
|>
|> How to SAVEPOINT and ROLLBACK TO in OCI ??

By parsing and executing the statements. Unlike commit and rollback, there are no special OCI commands for these. But you could simply do

oparse(cda, ..., "savepoint a", ...);
oexec(cda);

for example.

|>
|>
|> --
|> Sincerely Yours,
|> Sanny Sanoff

---

Scott Urman Oracle Corporation surman_at_us.oracle.com

---

Author of _Oracle PL/SQL Programming_ ISBN 0-07-882176-2 Published by Oracle Press - http://www.osborne.com/oracle/index.htm

---

"The opinions expressed here are my own, and are not necessarily that of  Oracle Corporation"

---

Received on Tue Sep 03 1996 - 00:00:00 CEST