ORA-01461异常

ORA-01461错误我有一个表privilege 直接用sqlSQL codeinsert into privilege (company_id , module ,lang_

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.