oracle - Oracle 错误：值大于该列允许的指定精度

Question

插入以下值时出现以下错误：

第 1 行出现错误：ORA-01438：值大于此列允许的指定精度

    insert into comands values(
        '11111111A',
        '05MAY21',
        col_products(
                t_products(
                        'Rice with chicken',
                        1000,
                        (select ref(inf) from infoNutri inf where inf.num_calories=1000)
                    )
            )
    );
    
    create or replace type t_comandas is object(
        id varchar2(9),
        date date,
        products col_products 
    );
    /
create or replace type t_products as object(
    name varchar2(20),
    price number(4,2),
    info_nutritional ref t_infoNutritional
)

标签： oracle