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

    Oracle error: update_cursor z700; ... table or view does not exist

    • Article Type: General
    • Product: Aleph
    • Product Version: 20, 21, 22, 23

    The error message

    Oracle error: update_cursor z700
    ORA-00942: table or view does not exist


    appears repeatedly in

    * the www_server log in connection with the DLF-CIRC-ACTS service when Primo users do "My Account" to display their loans, fines, etc;

    * the www_server log when an Aleph OPAC user does "My Library Card"; or

    * the pc_server log when trying to save or create a patron record.

    Resolution
    Define the z700 table in the $pw_library. (Even if the site is not using ILL, the z700 needs to be present to prevent this error message from appearing in the logs.)

    Additional Information


    If the error occurs in running p_file_20, consult KB16384-16466 p_file_20: "check_z303 routine failed"; "Z303-ILL-LIBRARY is not valid"

    Category: Web OPAC


    • Article last edited: 10/8/2013