OraFAQ Forum: JDeveloper, Java & XML » why I can't use "distinct" in a SQL with CLOB

Home » Developer & Programmer » JDeveloper, Java & XML » why I can't use "distinct" in a SQL with CLOB

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

why I can't use "distinct" in a SQL with CLOB [message #91507]

Mon, 14 October 2002 18:02

nesan
Messages: 1
Registered: October 2002

Junior Member

select distinct W.NEWSID,
W.CONTENT.extract('CONTENT').getClobVal() CONTENT
from
PM.ZWYWB W

errors:
W.CONTENT.extract('CONTENT').getClobVal() CONTENT
*
ERROR occured at line 2
ORA-00932: inconsistent datatypes: -required but CLOB found

Report message to a moderator

Re: why I can't use "distinct" in a SQL with CLOB [message #91509 is a reply to message #91507]

Tue, 15 October 2002 05:06

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

it a restriction with LOB's.
quoting the doc's

Code: [Select all] [Show/ hide]

LOBs are not allowed in GROUP BY, ORDER BY, SELECT DISTINCT, aggregates and     JOINS. However, UNION ALL is allowed on tables with LOBs. UNION, MINUS, and     SELECT DISTINCT are allowed on LOB attributes if the object type has a MAP     or ORDER function.

Report message to a moderator

Previous Topic:	JDBC Encryption
Next Topic:	Re: Oracle Forms 6i Documentation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Mar 14 07:35:52 CDT 2025