insert into tf_content
(CONTENT_ID,
CREATE_TIME,
MOOD_ICON,
TITLE,
CONTENT --clob类型
)
SELECT hn_content.nextval,
ISSUEDATE,
DIRECTORY,
MSGTITLE,
TO_LOB(MSGCONTENT) --long类型
FROM CSMESSAGE@hnold; --dblink
看一下这个语句是否能运行通过,如果可以写在存储过程也是OK的啦!
ORA-00997 illegal use of LONG datatype
Cause: A value of datatype LONG was used in a function or in a DISTINCT, WHERE, CONNECT BY, GROUP BY, or ORDER BY clause. A LONG value can only be used in a SELECT clause.
Action: Remove the LONG value from the function or clause.