I don't spend a lot of time in APEX, so please forgive me is this seems like a
silly question.
I have a view with two blobs holding pdf's.
The following query executes fine in sql developer but raises ORA-20000: Oracle
Text error: DRG-50901: text query parser syntax error on line 1, column 1 when
executed in an APEX report. Note: this happens even if :p6_search_term is null.
Any ideas where to start looking?
select CASE_ID,
CONSTITUENT,
DOCUMENT_DATE,
CASE_TYPE_NAME,
STAND_TYPE_NAME,
HOW_RECEIVED_TYPE_NAME,
TONE_TYPE_NAME,
orig_fullname,
resp_fullname,
dbms_lob.getlength(orig_doc) ORIG_DOC,
dbms_lob.getlength(resp_doc) RESP_DOC
from WCS.VWCASE_DOCUMENTS cd
where (cd.subject_id = :p6_subject or :p6_subject is null)
and (cd.case_type = :p6_case_types or :p6_case_types is null)
and (cd.stand_type = :p6_stand_types or :p6_stand_types is null)
and (cd.tone_type = :p6_tone_types or :p6_tone_types is null)
and (cd.how_received_type = :p6_how_received or :p6_how_received is null)
and ((:p6_search_term is not null and (contains(orig_doc, :p6_search_term) >
0) or :p6_search_term is null)
or (:p6_search_term is not null and (contains(resp_doc, :p6_search_term) > 0)
or :p6_search_term is null))
order by case_id;
===================================
Robert P. LockardOracle ACEPresident Oraclewizard.com, Inc. The question is not
“who is going to let me,” it's “who is going to stop me." Ayn Rand
(cell) 571.276.4790
(office) 410.766.6960
(fax) 410.766.0332
twitter @navonpilot
youtube https://www.youtube.com/user/n4281k
blog: http://www.oraclewizard.com
