How about using some standard SQL string compariuson functions/operators? Like "<>", "LIKE", "INSTR" - you choose one. Something like:
orCode:... if l_buffer LIKE '#%' then insert into TEST ... end if; ...
or ...... I mean, totaly basic SQL functions/operators.Code:... if INSTR(l_buffer,'#') > 0 then insert into TEST ... end if; ...




Reply With Quote