Re: Long Strings in Oracle

hi senor,

i didnt think the limitation was specifically w/ oracle, but with ODBC.... we had a similar issue, but didn't hit that limit until we were well into testing...

oracle said that they supported 64k for vc2 fields, but that you would hit the wall at 2k thru odbc - they said that you would not hit this limit using oracle forms and / or one of their precompilers (?) ....

we rewrote a pkg to use a series of 2k fields to mimic the long text field functionality - you may be able to do that, then do a search on "select .. from ... where 'textexpression' like %f1||f2||f3% "

• i am reaching on the second part there, but it's about time for the weekend <g>

good luck
brent

Hank Riehl wrote in message <7o41kk$6g3_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
Received on Fri Aug 13 1999 - 15:38:59 CDT