Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: LONG Datatype and Substrings

Re: LONG Datatype and Substrings

From: Jared Still <jkstill_at_bcbso.com>
Date: Tue, 16 May 2000 09:11:33 -0700 (PDT)
Message-Id: <10499.105752@fatcity.com>


Ahh, the joys of Long datatypes.

The best thing to do is avoid them.

Or convert them to LOB's.

You will have to use PL/SQL to fetch
pieces of the long into a variable,
search the variable, and do so until
the entire LONG has been searched.

Some fun eh?

Jared

On Tue, 16 May 2000, Stephen Dance wrote:

>
> I know there was a discussion on this on the list only the other day,
> but please can someone just update me on it.
>
> A developer has just asked how to select from a table where the
> condition part of the statement refers to a LONG datatype column. They
> then get ORA-00997 Illegal use of LONG datatype.
>
>
> Thanks
> STEVE
> --
> Author: Stephen Dance
> INET: steved_at_capbankcf.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).
>

Jared Still
Certified Oracle DBA and Part Time Perl Evangelist ;-) Regence BlueCross BlueShield of Oregon
jkstill_at_bcbso.com - Work - preferred address Received on Tue May 16 2000 - 11:11:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US