Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> q: sync pl/sql and dynamic ddl statement ?
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 - 02:31:47 CDT