My a stored procedure is written so
IF LENGTH (P_RKSJ) & gt; 0 AND P_RKSJ IS NOT NULL THEN
V_TJ:=V_TJ | | 'AND Y.R KSJ & gt;=TO_DATE (" '| | P_RKSJ | |
"', '- DD YYYY - MM HH24: MI: SS', ');
END the IF;

IF LENGTH (P_RKJS) & gt; 0 AND P_RKJS IS NOT NULL THEN
V_TJ:=V_TJ | | 'AND Y.R KSJ & lt;=TO_DATE (" '| | P_RKJS | |
"', '- DD YYYY - MM HH24: MI: SS', ');
END the IF;

IF LENGTH (P_SJHM) & gt; 0 AND P_SJHM IS NOT NULL THEN
V_TJ:=V_TJ | | 'AND Y.S JHM like' ' '| | P_SJHM | |' % '"';
END the IF;

IF LENGTH (P_SJLX) & gt; 0 AND P_SJLX IS NOT NULL THEN
V_TJ:=V_TJ | | 'and Y.S JLX=' '| | P_SJLX | |' ' ' ';
END the IF;
Then how can use bind variables