Статичный Bornin : Супермаг Плюс (Супермаг 2000)

SQL> select distinct bornin from supermag.smcard;

BORNIN
--------------------------------
3B5DA96C2CF545469B8582C31677DDDE

SQL> select bornin from supermag.smcard where article='0';

BORNIN
--------------------------------
3B5DA96C2CF545469B8582C31677DDDE

SQL> select length(bornin)from supermag.smcard where article='0';

LENGTH(BORNIN)
--------------
            32

SQL> update supermag.smcard set bornin='00000000000000000000000000000000' where article='0';
update supermag.smcard set bornin='00000000000000000000000000000000' where article='0'
                                          *
ERROR at line 1:
ORA-20102: Попытка изменить код базы происхождения артикула ORA-06512: at "SUPERMAG.CORE", line 323
ORA-06512: at "SUPERMAG.SMCARDFIXATTR", line 32
ORA-04088: error during execution of trigger 'SUPERMAG.SMCARDFIXATTR'

SQL> alter trigger SUPERMAG.SMCARDFIXATTR disable;

Trigger altered.

SQL> update supermag.smcard set bornin='00000000000000000000000000000000' where article='0';

1 row updated.

SQL> commit;

Commit complete.

SQL> alter trigger SUPERMAG.SMCARDFIXATTR enable;

Trigger altered.

SQL>