Query Progression PL/SQL Syntax

I cannot thank everyone enough for their help and I promise the last question I should have on this project. The issue is just that I am learning PL/SQL and my ablity to understand the syntax is still very undeveloped.



I have the following PL/SQL which is currently working well:

DECLARE
   v_query   VARCHAR2 (4000);
   v_search_string VARCHAR2(4000);
   
BEGIN
   v_query := 'SELECT   ';

  v_search_string := '<query>
   <textquery>
     <progression>
       <seq>'||:p1_search_string||'</seq>
       <seq>'||replace(:p1_search_string,' ',' $')||'</seq>
       <seq>'||replace(:p1_search_string,' ',' ?')||'</seq>
     </progression>
   </textquery>
</query>';


   IF :p1_search_string IS NOT NULL
   THEN
      v_query := v_query || 'score (1) relevance, ';
   ELSE
      v_query := v_query || '''100%'' relevance, ';
   END IF;

   v_query :=
      v_query || 'SUBSTR (website, INSTR (website, ''/'') + 1) '
              || 'document,' || 'ID, ';

   IF :p1_search_string IS NOT NULL
   THEN
      v_query :=
            v_query
         || 'NVL2 '
         || '(:p1_search_string, '
         || 'ctx_doc.snippet '
         || '(''docsx'', '
         || 'ROWID, '
         || 'NVL (:p1_search_string, ''%''), '
         || '''<span style="color:darkgreen;'
         || 'font-weight:bold;font-size:14px;">'', '
         || '''</span>'' '
         || '), '
         || 'NULL '
         || ') snippet ';
   ELSE
      v_query := v_query || 'NULL snippet ';
   END IF;

   v_query := v_query || 'FROM docs ';

   IF :p1_search_string IS NOT NULL
   THEN
      v_query :=
            v_query
         || 'WHERE contains (document, ''' || v_search_string || ''', 1) > 0';
   END IF;

   v_query := v_query || 'ORDER BY 1 DESC ';
RETURN (v_query);
END;

Select allOpen in new window

I would like to add:
<seq>(NEAR((:p1_search_string),15,TRUE)) </seq>
 however whenever I try and add that into the <query> portion of the code I recieve errors stating that NEAR is not defined. For some reason I just cannot get the syntax correct.

Below is an example of what the code looks like in SQL and works for the below example:

 

select SCORE(1),website, document from docs WHERE CONTAINS(document,
'<query>
<textquery>
<progression>
<seq>(borrower solicitation) </seq>
<seq>($borrower $solicitation) </seq>
<seq>(NEAR((borrower,solicitation),15,TRUE)) </seq>
<seq>(NEAR(($borrower,$solicitation),15,TRUE)) </seq>
<seq>(borrower% solicitation%) </seq>
<seq>(FUZZY(borrower,,,WEIGHT) FUZZY(solicitation,,,WEIGHT))</seq>
</progression>
</textquery>
 <score datatype="INTEGER" algorithm="COUNT"/>
</query>', 1)>0
Order by SCORE(1) desc

Select allOpen in new window