Error ORA-01741: illegal zero-length identifier

[ttrimis]

Im getting this error:
ORA-01741: illegal zero-length identifier

when I try to execute the following insert from sqlplus

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');

The same insert works perfectly from PL/SQL Developer

Any help, suggestions etc please?

Theodor Trimis

[BeefStu]

describe your table

[stecal]

Are you telling SQL*Plus to run the 12:00 am','5745'); script?

[vnktummala]

most of the times SQL * Plus read @ differently even it is part of insert values which is not the case with PL/SQL developer or TOAD. Check out in that front.

Thanks,

[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 '@';