Active Record: ERROR: ORA-01704: string literal too long

[eluser]rachj[/eluser]
Hello,

I am trying to use ActiveRecord class to insert long strings into an oracle table. The error I get is below:


A Database Error Occurred

Error Number:

INSERT INTO "FEATURE" ("FEATURE_ID", "RESIDUES") VALUES ('1526', 'Here I input a very long string > 4000 charachters')

If I try this sql statement in oracle using command line, I get the error:
"ERROR: ORA-01704: string literal too long"

I would appreciate if someone could help me with how to work around this error.

Thanks
RJ