RE: ORA-00911: invalid character

Why not? Formatting makes a document readable. Just put the Word docs in a BLOB column and use interMedia Text to index and query them. It works very well.

Jack C. Applewhite
Database Administrator
Austin Independent School District
Austin, Texas
512.414.9715 (wk)
512.935.5929 (pager)
JApplewhite_at_austin.isd.tenet.edu

                                                                                                           
                      "Odland, Brad"                                                                       
                      <Brad.Odland_at_qtiw        To:       Multiple recipients of list ORACLE-L              
                      orld.com>                 <ORACLE-L_at_fatcity.com>                                     
                      Sent by:                 cc:                                                         
                      root_at_fatcity.com         Subject:  RE: ORA-00911: invalid character                  
                                                                                                           
                                                                                                           
                      04/17/2003 03:16                                                                     
                      PM                                                                                   
                      Please respond to                                                                    
                      ORACLE-L                                                                             
                                                                                                           
                                                                                                           

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).






-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: JApplewhite_at_austin.isd.tenet.edu

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).