>From 8.1.x upwards, there is a TO_LOB function to convert from longs. The best way would be for the app to understand CLOB's - but I guess thats not an option.
If the longs are less than 32k, then you can use PL/SQL to search them - PL/SQL will support a varchar2(32767). hth connor --- Rich Davidson <[EMAIL PROTECTED]> wrote: > hey all, > > i'm in your typical situation of "we don't need a > dba...oracle is an app so > the bizapps guy can handle it"....right...now to > reality. there is a column > in our database (oracle is the back end of our crm > package) that is defined > as a long and they want to do keyword searches on > it. i've found out that > you can't use type long in a where clause. > > i guess i have a few questions and i'm going to > assume the answers (if > anyone answers...please oh please do) will be a > matter of opinion. am i > better off creating a new column in the existing > table of the type clob or > blob? should i create a new table to store this > data? and what would be my > best way to keep these columns in sync...every time > someone updated the long > column i would want my new column updated to reflect > the change. > > right now we're on 8.0.6/win 2k...but could upgrade > to 8.1.7 (means > upgrading our crm package too) if it makes this > process easier. > > thanks in advance for the help and not being a dba i > hope what i wrote makes > sense! > *:-.,_,.-:*'``'*:-.,_,.-:*'``'*:-.,_,.-: > rich davidson > dynamicsoft Inc. > east hanover, nj > > [EMAIL PROTECTED] > t. +1-973-503-6169 > f. +1-973-952-5050 > > ===== Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue" __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
