Re: Long Strings in Oracle

ConText cartridge (Oracle8) may help you task.

bgeake_at_my-deja.com wrote:

> I think you're stuck there and will have to retrieve the entire record
> and process on the client side. Unpleasant but then unpleasantness is
> part of what keeps Oracle salaries up. Except mine.
>
> Bill.
>
> In article <7o41kk$6g3_at_news-central.tiac.net>,
> "Hank Riehl" <hankr_at_skillview.com> wrote:
> > We'd like to add the capability for our application to store an
> > employee's resume and permit management to run keyword search queries
> > against the resume library using LIKE or CONTAINS in the WHERE clause.
> >
> > Oracle 7.x seems to have a 2000 character limitation on the VARCHAR2
> > datatype which is too few characters. The Oracle LONG datatype does
> not
> > permit references to it in a SQL WHERE clause.
> >
> > Any ideas on how to achieve this functionality? I can't believe that
> > Oracle's character-handling is so restrictive.
> >
> > Thanks... Hank
> >
> >
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.

--
Breno de Avellar Gomes
DBMS Developer

Arquivo-Sistemas de Bases de Dados
P. O. Box 5006
4017-001 Porto
Portugal

brenogomes_at_ieee.org
Cellular: +351 931 7383469
ICQ # 35567342 Received on Tue Aug 17 1999 - 21:36:12 CDT