Error ORA-01741: illegal zero-length identifier

[onedbguru]

Try:

set escape on;
INSERT INTO messages VALUES
('631','3026','move range automatic frequent degree cloud I there waiting story such sand property fiction','May 2, 07 \@ 12:00 am','5745');

Note the \ preceding the @ sign.

or
INSERT INTO messages VALUES
('631','3026','move range automatic frequent degree cloud I there waiting story such sand property fiction','May 2, 07 @ 12:00 am','5745') ESCAPE '@';