Report question- INSTR built-in
Date: Mon, 28 Aug 2000 21:45:30 GMT
Message-ID: <8oemhk$7qg$1_at_nnrp1.deja.com>
[Quoted] I am trying to check to see if a passed in parameter has a wildcard embedded in it and them creating my where clause accordingly. The following is my function, the instr part does not seem to be working. It compiles, however, no matter what I put in :p_jon_list it is calling [Quoted] the LIKE part not the else part.
function AfterPForm return boolean is
v_quote varchar2(1) := chr(39);
--v_wild_card boolean;
begin
IF INSTR(':p_jon_list','%',1)>0 then
:p_jon_list := 'Where job_order_primary.jon
LIKE('||v_quote||:p_jon_list||v_quote||')';
else
:p_jon_list := 'Where job_order_primary.jon IN
('||v_quote||:p_jon_list||v_quote||')';
end if;
return (TRUE);
Diane
perkinsdt_at_navair.navy.mil
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Mon Aug 28 2000 - 23:45:30 CEST