oracle,blob字段类型的问题

[yao101495]

A 表 (
name varchar2
age var char2
pic blob ,
modigy_flag number
)

b 表 (
name varchar2
age var char2
pic blob
)

怎么把A表的name.age,pic的所有记录插入到b表啊，插入blob字段时候出错.~请高手指教啊~~

[Eric_1999]

insert into B(name, age, pic) select name, age, pic from A

[gw_delphi]

楼上正解