>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 <RDavidson_at_dynamicsoft.com> 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
>
> rdavidson_at_dynamicsoft.com
> 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: hamcdc_at_yahoo.co.uk
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: ListGuru_at_fatcity.com (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).
Received on Wed Nov 14 2001 - 11:26:46 CST
