Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Problem inserting the string "agenda"

Re: Problem inserting the string "agenda"

From: Jim Lyons <jlyons4435_at_my-deja.com>
Date: 2000/08/10
Message-ID: <8muhmn$o2i$1@nnrp1.deja.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US