4312:20100927:101526.603 [Z3005] Query failed: [-1] ORA-06550: line 58, column 83:
PL/SQL: ORA-01704: string literal too long
ORA-06550: line 58, column 1:
PL/SQL: SQL Statement ignored
[begin
...
...
insert into history_text (id,itemid,clock,value) values (3792433,57033,1285607722,'lots of text');
end;
]

Fix is by setting bind variables or by using dbms_sql

I found this solution here:
http://www.experts-exchange.com/Database/Oracle/Q_21706207.html

Ask Tom has a better explanation if you want to use
http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:7032414607769