Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1996
  • Last Modified:

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?
0
sakthikumar
Asked:
sakthikumar
2 Solutions
 
sdstuberCommented:
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 ShaikCommented:
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

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now