Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2003
    Location
    Vienna, Austria
    Posts
    2

    Red face Troubles searchin string in CLOB with DBMS_LOB.INSTR()

    Hi folks!

    I'm having troubles searching for a given string in a CLOB-field. I use DBMS_LOB.INSTR(), but it always returns only one record, even when there are certainly many more.

    The funny thing is: " SELECT count(id) FROM section WHERE dbms_lob.INSTR(section.text, 'Hilfe') > 0 " returns for example 252.

    But if the query is " SELECT header FROM section WHERE dbms_lob.INSTR(section.text, 'Hilfe')>0 " it returns only one record.

    Any help is greatly appreciated, it's for the website of a humanitarian NGO, so it counts as a good deed.

  2. #2
    Join Date
    Jul 2003
    Location
    US
    Posts
    314
    Cool,
    I am also stuck at the same problem, as to how to search for CLOB objects.
    I am glad to see ur question right when I needed the solution so badly.

    I posted two questions earlier but didnt get a response.
    Good to see that you have some idea as to how to proceed.

  3. #3
    Join Date
    Jul 2003
    Location
    US
    Posts
    314
    dbms_lob.INSTR() function really works perfect for me.
    Thanx dude for mentioning the function in the site.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •