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