Help with Script to convert Long to Clob

[akkerend]

SELECT long_column
INTO long_plsql_variable
FROM long_table
truncates the long after about 32k, the maximum size of long and varchar2 pl/sql variable.
INSERT INTO lob_table
SELECT n, TO_LOB(long_column)
FROM long_table
inserts the complete long column into the lob column.