Re: Auto-Commits in Stored Procedures?

From: <Solomon.Yakobson.B_at_bayer.com>
Date: Mon, 08 Mar 1999 21:58:32 GMT
Message-ID: <7c1h62$rp8$1@nnrp1.dejanews.com>

> Unless Oracle has changed a bunch of stuff quite recently, you can not
> execute DDL (create table, truncate table, etc.) from a stored
> procedure so that is not what's happening. Try running from SQL+ and
> see if you can roll it back. If you're running it from some other
> tool, the tool could have an auto-commit "feature".
>
> Gene Hubert
> Graham, NC
>
>

That "quite recently" happened couple years ago when oracle introduced DBMS_SQL and DBMS_DDL packages (dynamic sql).

SOlomon Yakobson

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Mar 08 1999 - 15:58:32 CST