create your own "is_number" function

create or replace function is_number (p_value in varchar2)
return boolean as
l_number number;
begin
l_number := p_value;
return true;
exception
when others then
return false;
end is_number;