Re: Long Strings & Oracle

You can use PL/SQL instead of SQLPlus, PL/SQL can handle LONG's with a length of 32 Kb (minus some few bytes). If you want to have LONG larger the 32Kb, you must access them through OCI (Oracle's call Interface), or some simular interface programing interface.

And yes Oracle's character-handling is restrictive. (remeber to set the NLS_LANG environment variable before you starts working with LONG)

Hank Riehl wrote in message <7o41rm$6sa_at_news-central.tiac.net>...
>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 Riehl
>
>
>
Received on Tue Aug 03 1999 - 10:13:55 CDT