当前位置: 代码迷 >> Oracle管理 >> ORA-01461异常
  详细解决方案

ORA-01461异常

热度:34   发布时间:2016-04-24 05:32:38.0
ORA-01461错误
我有一个表privilege 直接用sql
SQL code
insert into privilege (company_id , module ,lang_id ,program_id ,program_name , priv_id ,priv_desc )values ('21','測試報表_P','chs','CM_RPT054','測試報表',51,'測試報表')
插入没有问题,在pl/sql中
用select * from privilege where 1 = 2 for update 执行eidt data 然后在把上面值填入,执行,居然报ORA-01461错误ORA-01461 can bind a LONG value only for insert into a LONG column

------解决方案--------------------
ORA-01461 can bind a LONG value only for insert into a LONG column

Cause: An attempt was made to insert a value from a LONG datatype into another datatype. This is not allowed.

Action: Do not try to insert LONG datatypes into other types of columns.