最初由 wawa 发布
[B]CREATE TABLE long_table (n NUMBER, long_col LONG);
CREATE TABLE lob_table (n NUMBER, lob_col CLOB);
在sqlplus里用这样的语句是成功的:
INSERT INTO lob_table
SELECT n, TO_LOB(long_col) FROM long_table;
已创建0行
但这样就失败了:
BEGIN
INSERT INTO lob_table
SELECT n, TO_LOB(long_col) FROM long_table;
END;
/
ERROR 位于第3行:
ORA-06550: line 3, column 13:
PLS-00201: identifier 'TO_LOB' must be declared
ORA-06550: line 2, column 1:
PL/SQL: SQL Statement ignored [/B]
首先,我建议你查一下 to_clob() 的帮助
其次,建议你用 insert into lob_table(n, lob_col ) as select n, to_lob(long_col) from long_table
|