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.