exact fetch returns more than requested number of rows
1 2 3 4 5
--查询到 per_box_qty 是多条记录 select per_box_qty into l_box_num from som_packing_item_setup where organization_id = p_org_id and assembly_item_id = p_item_id;
# ORA-06502 numeric or value error: character string buffer too small
1 2 3 4 5
--数据库中字段 location varchar2(40) --当 location 存储的字段大于 30 时 插入 l_ship_to_location 会出现此错误 l_ship_to_location varchar2(30); select hcsua.location into l_ship_to_location from hz_cust_site_uses_all hcsua;
# ORA-01858 a non-numeric character was found where a numeric was expected
1 2
--sysdate 是日期类型,'R' 是字符类型,类型不匹配 select nvl(sysdate,'R') from dual;