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 -> q: sync pl/sql and dynamic ddl statement ?

q: sync pl/sql and dynamic ddl statement ?

From: Ted Chyn <ericis6_at_home.com>
Date: Thu, 21 Jun 2001 07:31:47 GMT
Message-ID: <DphY6.331625$oc7.33826949@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 - 02:31:47 CDT

Original text of this message

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