Re: Incredible ! Oracle HELP PLEASE !

From: Christian GILBERT <externe.gilbert_at_francetelecom.com>
Date: Fri, 28 Jun 2002 11:36:14 GMT
Message-ID: <1103_1025264174@10.193.118.17>

Sur Thu, 27 Jun 2002 16:15:38 +0100, "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> a écrit:

> SQL> insert into LGC02 ( ID_LGC02,TIARLG, TITRLG, FECHLG, HORALG, WSIDLG,
> USERLG,
> 2 DATA_A)
> 3 VALUES (ID_LGC02.nextval, 'O',
> 4 'A', 260602, 165225, 'SERVIDOR ',
> 5 'CGIFS ',
> 6 'VC11020601000011020601
> 7
> 0000000000000000000000000000000000000000000000000000000000000000000000000000
> 8 ');
>
> 1 row created.
>
> SQL> commit;
>
> Commit complete.
>
> SQL> insert into LGC02 ( ID_LGC02,TIARLG, TITRLG, FECHLG, HORALG, WSIDLG,
> USERLG,
> 2 DATA_A)
> 3 VALUES (ID_LGC02.nextval, 'O',
> 4 'A', 260602, 165225, 'SERVIDOR ',
> 5 'CGIFS ',
> 6 'VC11020601000011020601
> 7
> 0000000000000000000000000000000000000000000000000000000000000000000000000000
> 8 ');
>
> 1 row created.
>
> SQL> rollback;
>
> Rollback complete.
>
> SQL> insert into LGC02 ( ID_LGC02,TIARLG, TITRLG, FECHLG, HORALG, WSIDLG,
> USERLG,
> 2 DATA_A)
> 3 VALUES (ID_LGC02.nextval, 'O',
> 4 'A', 260602, 165225, 'SERVIDOR ',
> 5 'CGIFS ',
> 6 'VC11020601000011020601
> 7
> 0000000000000000000000000000000000000000000000000000000000000000000000000000
> 8 ');
>
> 1 row created.
>
> SQL> commit;
>
> Commit complete.
>
> SQL> insert into LGC02 ( ID_LGC02,TIARLG, TITRLG, FECHLG, HORALG, WSIDLG,
> USERLG,
> 2 DATA_A)
> 3 VALUES (ID_LGC02.nextval, 'O',
> 4 'A', 260602, 165225, 'SERVIDOR ',
> 5 'CGIFS ',
> 6 'VC11020601000011020601
> 7
> 0000000000000000000000000000000000000000000000000000000000000000000000000000
> 8 ');
>
> 1 row created.
>
> SQL> commit;
>
> Commit complete.
>
> SQL> insert into LGC02 ( ID_LGC02,TIARLG, TITRLG, FECHLG, HORALG, WSIDLG,
> USERLG,
> 2 DATA_A)
> 3 VALUES (ID_LGC02.nextval, 'O',
> 4 'A', 260602, 165225, 'SERVIDOR ',
> 5 'CGIFS ',
> 6 'VC11020601000011020601
> 7
> 0000000000000000000000000000000000000000000000000000000000000000000000000000
> 8 ');
>
> 1 row created.
>
> SQL> rolback;
> SP2-0042: unknown command "rolback" - rest of line ignored.
> SQL> rollback;
>
> Rollback complete.
>
> SQL> select ID_LGC02 from LGC02;
>
> ID_LGC02
> ----------
> 1
> 3
> 4

Ooopss...
I didn't understand you wanted to rollback your transactions... I don't see anything else than code around your problem : The transaction should only be made when you are sure that it must be commited. For example, your application should only perform an insert/commit when your end user clics commit. If he clics rollback, nothing should be sent to the database.

Christian GILBERT
SNPI DTO/SGBD Oracle
01 55 88 41 21 Received on Fri Jun 28 2002 - 06:36:14 CDT