Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Problem inserting the string "agenda"
There's no reason why the string itself poses a problem. Here are
a few possible causes off the top of my head:
1) invalid syntax in the insert command
2) the field in the table isn't big enough (it has to allow for
a length of at least 6)
3) the datatype of the field is incompatible with a string
4) you need to surround the string with single quotes. You used
double quotes in the example. If you really did that SQL will assume it's a column name, not a literal string. 5) you forgot to issue the command 'sqlplus' so instead of typing
the command in SQL*PLUS you entered it on the Unix command line.
If it's none of these, send in your table description and the *exact* command you're using to insert.
In article <8mufae$cjg$1_at_diana.bcn.ttd.net>,
"Santi Rodríguez" <srodriguez_at_ondarambla.es> wrote:
> Hi,
>
> I'm trying to insert the string "agenda" in one field but oracle
return an
> error. I tnink that is because of the substring "end" in "agenda".
> What can I do?
>
> thank you very much.
>
> Santi
>
>
-- Jim Lyons | Network Systems Analyst Entertech - The IC2 Institute | 512-482-0273, ext. 269 University of Texas at Austin | jlyons_at_weblyons.com http://www.weblyons.com Sent via Deja.com http://www.deja.com/ Before you buy.Received on Thu Aug 10 2000 - 00:00:00 CDT
![]() |
![]() |