Re: q: sync pl/sql and dynamic ddl statement ?

DDL always does an implicit commit so there is no way of getting around it (unless someone proves otherwise!).

M

"Ted Chyn" <ericis6_at_home.com> wrote in message news:<DphY6.331625$oc7.33826949_at_news2.rdc2.tx.home.com>...
> sir: in pl/sql block contain execute immediate ddl statement such as
> 'create table test_1';
> when block is executing dynamic ddl sql statement is commited whether the
> whole pl/sql
> is sucessful or not. Is there a way to make dynamic sql in sync with pl/sql
> block code -i.e. if pl/sql fail no table will be created.
>
> thnx ted chyn
Received on Thu Jun 21 2001 - 09:40:23 CDT