ORA-29902: error in executing ODCIIndexStart() routine ORA-20000: Oracle Text error: DRG-50901: text query parser syntax error on line 1, column 19 -
select person_no sub_sys_individual_id, nm_e, nm_a, nvl(sex, -1) sex, nvl(prs_nat, -999) prs_nat, person_no, 'na' prog_where_not_allowed, 'na' udb_no, person_tp, pass_no ban_inq_tab contains (nm_e ,'xxstart juheti bt memed asmani%') >0 , (trans_flag null or trans_flag = 'c');
please help me in issue , getting parser syntax error
the error causing bt, reserved word. solution described in oracle community forum.
oracle text
No comments:
Post a Comment