The ROLLBACK don't cancel instructions

I have a script :

set autocommit off;
drop table pcomessaisuite;
commit;
set transaction read write;
create table pcomessaisuite (toto varchar(5)); alter table pcomessaisuite add toto3 varchar(6); rollback;
describe pcomessaisuite;

Normally the table ESSAISUITE wouldn't create and an error would be create on last line. But Oracle create the table in spite of the ROLLBACK.

Can you help me ?

Thank. Received on Thu Sep 06 2001 - 03:48:24 CDT