RE: ORA-00911: invalid character

Does anyone question the need to store bullets in an Oracle database?

What have we become....

BRad O.

-----Original Message-----
Sent: Thursday, April 17, 2003 2:07 PM
To: Multiple recipients of list ORACLE-L

is it possible to put it in a CLOB?
>
> From: kal inuganti <websphear_at_yahoo.com>
> Date: 2003/04/17 Thu PM 12:42:56 EDT
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Subject: ORA-00911: invalid character
>
> All,I am working on a project that requires inserting excerpts from a
Microsoft Word document into an Oracle Table. The word document excerpts contain special characters like bullets, quotes etc. Is there any way that I can work around this problem? Here is a sample SQL. I am not sure of what it looks like when you actually get this message. I have a bullet in my insert statement.
> insert into TABLE_1 (id, text) VALUES ('1', '
>
> Aaa');
> Thanks,-kalyan
>
>
> ---------------------------------
> Do you Yahoo!?
> The New Yahoo! Search - Faster. Easier. Bingo.
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Odland, Brad
  INET: Brad.Odland_at_qtiworld.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).