Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    SQL update doesn't actually take effect

    • Article Type: General
    • Product: Aleph
    • Product Version: 21

    Problem Symptoms:

     

    An SQL update or delete is executed (the "nnn rows updated" appears), but, checking in the GUI or Web, the change has not actually taken effect.
     

    Cause:

    Failure to include "commit" after the SQL update(s). For an SQL "update" or "delete" to take effect, it needs to be followed by a "commit" command, like this:
    SQL> update znn set yyy = zzz where ....;
    SQL> commit;

     

    Resolution:

    Include "commit" as the final command.

    There may be a series of related updates which should not take effect until all of them are completed.

    Such as:
    SQL> update <aaa ....>
    SQL> update <bbb ....>
    SQL> update <ccc ....>
    SQL> commit;

    Additional Information

    Important note: Ex Libris does not support SQL queries and strongly advices against any changes outside the application. 

    Before performing mass data updates or Aleph global changes the affected table(s) should be backed up using p_file_03 ("Export Database Tables") or an Oracle individual table backup.

     

    • Article last edited: 19/09/2017