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.
>
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', '
);
Thanks,
-kalyan
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: <rgaffuri_at_cox.net
INET: rgaffuri_at_cox.net
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).
Received on Thu Apr 17 2003 - 14:07:02 CDT
