Welcome to Oracle Communities
Register and Participate in Oracle's online communities. Learn from thousands of experts, get answers to your questions and share knowledge with peers.
I need to search inside BLOB segment for specific string.
I have tried two options , but non of them return row.
where dbms_lob.instr(my_blob, utl_raw.cast_to_raw('/PROD-NP-2009Version/Shared/Connections/Database'))>0
where dbms_lob.instr(my_blob, utl_raw.cast_to_raw('/PROD-NP-2009Version/Shared/Connections/Database'),1,1)>0
I am not sure that the string is exists , but would like to get your advise which option is should use future searches
This forum is ONLY for Sql Developer questions.
Please mark your thread ANSWERED and repost it in the Sql and Pl/Sql forum
SQL & PL/SQL
BLOBs are OPAQUE - they contain binary data, not strings.
You need to convert the BLOB to an appropriate datatype (e.g. CLOB) if you want to treat it as a 'string'. Repost in the other forum and you can get further help with your question.