Re: Anybody have an Oracle PL/SQL reference at hand?

>>
>>
>>>        BEGIN;
>>>            SAVEPOINT start;
>>>            INSERT INTO users VALUES(user || suffix);
>>>            EXIT;
>>>        EXCEPTION
>>>            WHEN UNIQUE_VIOLATION THEN
>>>                ROLLBACK TO start;
>>>                suffix := suffix + 1;
>>>        END;

> By the way, while I know Oracle won't abort the transaction, they might
> rollback whatever work the command that failed had done; I'm not really
> sure how that's handled.

How about a new EXCEPTION clause:

EXCEPTION NO ROLLBACKWHEN UNIQUE...

Chirs