This content has been marked as final. Show 5 replies
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;
If someone's response is helpful or correct, please mark it accordingly.*
Edited by: HamidHelal on Jan 23, 2013 6:36 PM