Re: When will long datatype no longer be supported

Your case against LOB is

(1) desupported in 10i
(2) Can't replicate through Oracle replication
(3) Can't do a Create Table As Select if a column is LONG
(4) LONG columns can't queried like SUBSTR(), INSTR(), DECODE, etc.

You case for them to move from LONG to LOB

(1) All of the above
(2) The existing data from LONG can be painlessly migrated to LOB using TO_LOB() Their case against moving from LONG

Code change required

You counter argument:

Code change is minimal. Almost all columns that are used as LONG can easily be converted to LOB.

Hope this helps.

Arup Nanda

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Monday, June 02, 2003 5:45 PM

> We are looking at purchasing a third party software package that is still
using longs. I am trying to make the case for forcing them to upgrade to lob's before we will purchase their software. Aside from the pain of having to deal with them - are they going to stop being supported soon? If so do you have any urls with details/dates?
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: John Shaw
> INET: John.Shaw_at_correctionscorp.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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).
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Arup Nanda
  INET: orarup_at_hotmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).