Re: Sql Server NTEXT fields

Dick,

Can you get hold of an INSO filter?

I am moderately persuaded that will do the trick, but I haven't tried it myself at all.

r,

Gus

Goulet, Dick wrote:

>Folks,
>
> I've got a copy of Oracle's Gateway to Sql Server so that we can
>integrate data from a third party, mom & pop created application with
>other data stored in Oracle. This application has a number of NTEXT
>fields where comments and the like are being stored, but in Rich Text
>Format. Now from the manual:
>
> You cannot use SQL*Plus to select data from a column defined as
>Microsoft SQL
> Server data type IMAGE, TEXT or NTEXT when the data is greater
>than 80
> characters in length.
>
>Anybody know how to strip the rtf stuff out especially from the
>Microsoft side??
>
>Dick Goulet
>Senior Oracle DBA
>Oracle Certified DBA
>--
>http://www.freelists.org/webpage/oracle-l
>
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l