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

    p_manage_18; SET Z52_SEQUENCE; "ORA-01722: invalid number"

    1. Last updated
    2. Save as PDF
    • Article Type: General
    • Product: Aleph
    • Product Version: 20

    Description:
    This is from the p_manage_18 log:

    old 2: SET Z52_SEQUENCE = (SELECT MAX(Z00_DOC_NUMBER) FROM &&1..Z00)
    new 2: SET Z52_SEQUENCE = (SELECT MAX(Z00_DOC_NUMBER) FROM ABC01.Z00)
    SET Z52_SEQUENCE = (SELECT MAX(Z00_DOC_NUMBER) FROM ABC01.Z00)
    *
    ERROR at line 2:
    ORA-01722: invalid number

    and this SQL shows the problem:

    SQL> SELECT MAX(Z00_DOC_NUMBER) FROM ABC01.Z00;

    MAX(Z00_D
    ---------
    ?»¿030095

    Resolution:
    As described in KB 3961, the correct_last_doc_number proc resets the z52 (util g/2) last-doc-number value.

    In this case the proc has found that the max z00_doc_number contains non-numeric characters.

    See KB 16384-22993 for how to handle this situation.

    • Article last edited: 10/8/2013