Re: Snapshot too old

pelliott_at_isd.net (Patrick Elliott) wrote:

> I am having a puzling problem. I have a pl/sql procedure that opens a
> cursor in a loop, inserts records from the cursor into a table, and if
> there are any errors, the error messages are inserted into a third
> table via an exception section. I am committing after every insert,
> the tables are empty before the procedure starts, but I am still
> getting a "SNAPSHOT TOO OLD" message. Here is a fragment of code
> similar to what I am working with, but simplified:
>
> Any answers to this question would be greatly appreciated.
>

        Do you REALLY need commit changes after EVERY insert? Try to commit on the end to see to results...

        Thanks,

--
Luis Santos
Relacional Consultoria
Rio de Janeiro - Brazil