barisist wrote:Hi barisist,
i have an item in oracle forms and datatype is char. But ı want to prevent user to enter special characters such as -,*,/, %.
how can ı do this?
Hope this helps..
declare b varchar2(10); begin FOR I IN 1..LENGTH(:Item_WORD) LOOP B := SUBSTR(:Item_WORD,I,1); if b in ('-','*','/','%') then message('not allowed.'); message('not allowed.'); raise form_trigger_failure; end if; END LOOP; end;