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

Thread: Urgent!! cannot SET SAVEPOINT in current PL/SQL session

  1. #1
    Join Date
    Dec 2000
    Posts
    87

    Angry

    Hi all,

    Does anyone out there know why I received such an error:

    ORA-00034: cannot SET SAVEPOINT in current PL/SQL session


    This is urgent, please help, thanks in advance.

    David.


  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Run

    Code:
    ALTER SESSION ENABLE COMMIT IN PROCEDURE;
    and try again.

    But if you get this through Forms note that a stored procedure or function may not issue a COMMIT or ROLLBACK when called by forms. Remove the COMMIT or the ROLLBACK from that procedure or function.



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