We help IT Professionals succeed at work.

How to give commit to an another session.

sakthikumar
sakthikumar asked
on
I have a session in which I just gave insert and update statements.
It is a plsql procedure and I am executing it from unix. Forgot to give a commit or a rollback in the procedure

How I can give a commit or a rollback on that session with the session ID.?

Also, What will happen If I kill that session in the middle?
Comment
Watch Question

Database Developer & Administrator
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2012
Commented:
you can't force a commit/rollback in somebody else's live session  - yikes!  that would be scary

if you kill it, it will rollback
CERTIFIED EXPERT
Commented:
it would be better for that plsql block running on unix to get complete where in you can perform the commit in the same session for the changes to get committed in db as well...

other than that, as sdstuber said, you can always roll it back by killing it any time..

Commented:
Start over!!  Your pl/sql block that is running won't do a thing!!
What is you business requirement ? Why do you want to do such a thing ? I'm sure there is another way of solving your problem.
Sean StuberDatabase Developer & Administrator
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2012

Commented:
why the B?


You failed to give any response or ask for additional information.   A penalty grades is inappropriate