Home » Developer & Programmer » JDeveloper, Java & XML » why I can't use "distinct" in a SQL with CLOB
why I can't use "distinct" in a SQL with CLOB [message #91507] Mon, 14 October 2002 18:02 Go to next message
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
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 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
it a restriction with LOB's.
quoting the doc's
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.  

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


Current Time: Fri Mar 29 10:04:06 CDT 2024