-
Error ORA-01741: illegal zero-length identifier
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
-
-
Are you telling SQL*Plus to run the 12:00 am','5745'); script?
-
problem with @ ???
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,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
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 '@';
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|