只能在insert语句的select子句中使用,
不能这么写:v_UnitLob := TO_LOB(v_UnitLong);
而应该这样:
CREATE TABLE new_print_media (
product_id NUMBER(6),
ad_id NUMBER(6),
press_release CLOB);
INSERT INTO new_print_media
(SELECT p.product_id, p.ad_id, TO_LOB(p.press_release)
FROM print_media p);
不能这么写:v_UnitLob := TO_LOB(v_UnitLong);
而应该这样:
CREATE TABLE new_print_media (
product_id NUMBER(6),
ad_id NUMBER(6),
press_release CLOB);
INSERT INTO new_print_media
(SELECT p.product_id, p.ad_id, TO_LOB(p.press_release)
FROM print_media p);
CREATE TABLE lob_table (n NUMBER, lob_col CLOB);
use this function to convert LONG to LOB values as follows: INSERT INTO lob_table
SELECT n, TO_LOB(long_col) FROM long_table;
包含to_lob函数的语句必须在本地动态执行
用execute immediate