How to give commit to an another session.

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?
sakthikumarAsked:
Who is Participating?
 
sdstuberConnect With a Mentor 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
0
 
Wasim Akram ShaikConnect With a Mentor 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..
0
 
BajwaCommented:
Start over!!  Your pl/sql block that is running won't do a thing!!
0
 
ytarkanCommented:
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.
0
 
sdstuberCommented:
why the B?


You failed to give any response or ask for additional information.   A penalty grades is inappropriate
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.