• Post Reply Bookmark Topic Watch Topic
  • New Topic

Oracle CLOB and Java ???????  RSS feed

 
Latif Laboussa
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I need your help with a technical issue
I would like to execute a query like :

select arct_node, artcl_idx,artcl_content_1 from content where
artcl_content_1 like '' %copper %"
and where arctl_content_1 is defined as CLOB. And when I excute the previous
query I have the message : incoherent data.
So, My question is how I can use the keyword like for a search in a CLOB column.
Regards
Latif
 
Sean MacLean
author
Ranch Hand
Posts: 621
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"laboussa",
Thanks for participating here at the Ranch. However, the name you are using does not comply with our naming convention described at
http://www.javaranch.com/name.jsp . Please log in with a new name, which meets these requirements.
You can change your name here.
Thanks.
Sean
 
sampy jagan
Ranch Hand
Posts: 34
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You cant compare 2 CLOB objects using " = " operator. Since CLOB is a LOB datatype you can make use of the package DBMS_LOB.INSTR() to do the same.
 
Latif Laboussa
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It works ,
Many thanks sampyjagan
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!