I am using Apex 4.2
I have a table that has BLOB content in it. I need to enable users to search for the BLOB content and display in report the list of files.
I am able to do the search with the query :
select FILENAME, BLOB_CONTENT
from BLOB_FILES_NEW
where CONTAINS(BLOB_CONTENT,':P14_SEARCH')>0
The query works fine in SQL Command. I created a report with the above query but instead I get error on display as :
failed to parse SQL query:
ORA-00932: inconsistent datatypes: expected - got BLOB
Totally clueless as why it does not work .Any help to fix this appreciated.
TIA,
Swetha