DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: rollback after execute the function

  1. #1
    Join Date
    Apr 2002
    Posts
    73

    rollback after execute the function

    I have a function that handing some update for the tables.
    Am I able to rollback the update after I execute the function in Sqlplus.

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Sure you can. Provided that the function does not commit/rollback by itself, of course.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    Apr 2002
    Posts
    73
    Am I able to type rollback in Sqlplus (same session) after I execute the function?

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by jmodic
    Sure you can. Provided that the function does not commit/rollback by itself, of course.
    Jeff Hunter

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width