Hi all, here might not be best place to ask this but,
Does anyone know how to rollback to particular check point not back to start
of transaction?
We are handling a socket connection as a single transaction and during a
socket communication, many packets can be received and contents of them will
be written to database many times. At the start of socket communication,
oracle database connection is opened and at the end, all writes to database
will be commited and closed.
What I want to do is, if I got faulty packet, rollback to just before that
faulty packet so that I don't lose contents of previous good packets.
TIA
Bob
Does anyone know how to rollback to particular check point not back to start
of transaction?
We are handling a socket connection as a single transaction and during a
socket communication, many packets can be received and contents of them will
be written to database many times. At the start of socket communication,
oracle database connection is opened and at the end, all writes to database
will be commited and closed.
What I want to do is, if I got faulty packet, rollback to just before that
faulty packet so that I don't lose contents of previous good packets.
TIA
Bob