Error when I try to give CREATE in a 4GL PROGRESS table

Question

Good afternoon. New to Progress here and I have a problem that didn’t happen before. When I created a new row in tables or in temporary tables, CREATE [table] was all I had to do. Now, in the last tables I tried, it has given a strange error. First appears the following: ORACLE error -2289 see "ORACLE Error Messages and Codes Manual".(1252) After clicking OK, the following error appears: **the sequence does not exist

The code that I wrote is not very large and is quite simple, so I don’t really know the problem. The create part is as follows.

IF quantidade = 1 THEN DO:
        ...
    END.
    ELSE DO:
        create plan_embal.
        ASSIGN
        plan_embal.cod_emit = pi-cod-emit
        plan_embal.item = pc-item
        plan_embal.observacoes = pc-observacoes
        .
    END.

Answer 1

We checked everything here and noticed that the sequence was with a different name from the table. By changing this, putting the sequence as the same table name plus _SEQ, everything worked perfectly. Thank you.