Hi!

What happens to prepared sp when transaction commited or rolled back?
Is it unprepared now and should be prepared again?

Mike