Re: The ROLLBACK don't cancel instructions

The result of the execution :

Table dropped

Commit complete

Transaction set

Table created

Table altered

Rollback complete
Name Type Nullable Default Comments ----- ----------- -------- ------- -------- TOTO VARCHAR2(5) Y
TOTO3 VARCHAR2(6) Y "Ben-oui" <aslamette_at_free.fr> a écrit dans le message news: sLGl7.3680$_M3.4388988_at_nnrp5.proxad.net...
> 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 PCOMESSAISUITE 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:54:04 CDT