Re: Long Strings in Oracle

From: <bgeake_at_my-deja.com>
Date: Tue, 17 Aug 1999 12:52:29 GMT
Message-ID: <7pblu8$sr9$1@nnrp1.deja.com>

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. Received on Tue Aug 17 1999 - 07:52:29 CDT