Maybe a trivial question... I am able to insert multiline values in a VARCHAR2 column using SQL*Plus: --- file x.sql --- Insert into EMAILTEMPLATES (FOLDERNAME,TEMPLATENAME,SUBJE CT,DESCRIPTION,BODY,DELETED,TE MPLATEID) values ('Public','Target Crossed!','Target Crossed!','Fantastic Sales Spree!','Congratulations!