Path: text.usenetserver.com!out04b.usenetserver.com!news.usenetserver.com!in04.usenetserver.com!news.usenetserver.com!nx02.iad01.newshosting.com!newshosting.com!69.16.185.16.MISMATCH!npeer02.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!postnews.google.com!d1g2000hsg.googlegroups.com!not-for-mail
From: wfholmes@yahoo.com
Newsgroups: comp.databases.oracle.server
Subject: Re: Querying DBA_VIEWS column
Date: Fri, 8 Aug 2008 09:09:37 -0700 (PDT)
Organization: http://groups.google.com
Lines: 17
Message-ID: <51d5a434-f2b1-4747-ac85-5225c42554d1@d1g2000hsg.googlegroups.com>
References: <5hYmk.16083$cW3.4434@nlpi064.nbdc.sbc.com>
NNTP-Posting-Host: 96.255.143.106
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1218211777 30075 127.0.0.1 (8 Aug 2008 16:09:37 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 8 Aug 2008 16:09:37 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: d1g2000hsg.googlegroups.com; posting-host=96.255.143.106; 
 posting-account=RVgsEwkAAADYSL0EI0YKZEQA4-58wMcF
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; (R1 1.5); 
 .NET CLR 1.0.3705; Media Center PC 4.0; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe)
Xref: usenetserver.com comp.databases.oracle.server:447057
X-Received-Date: Fri, 08 Aug 2008 12:09:37 EDT (text.usenetserver.com)

On Aug 8, 9:55=A0am, "Dereck L. Dietz" <diet...@ameritech.net> wrote:
> Oracle 10.2.0.1.0
> Windows 2003 Server
>
> My manager is trying to run this query against the DBA_VIEWS column:
>
> SELECT * FROM DBA_VIEWS WHERE OWNER =3D 'HBL' AND TEXT LIKE '%PRV_SGND_DI=
%'
>
> but receives ORA-00932 because the TEXT column in the DBA_VIEWS is a LONG
> column.
>
> Does anybody know a way around so that the column can be searched?
>
> Thanks.

Go to asktom and search for getlong (it's a pl/sql function).