Re: function to get only numbers

"Philippe Makowski" <makowski.philippe_at_wanadoo.fr> wrote in message news:<9i05pr$i8b$1_at_wanadoo.fr>...
> why this function does not compile ?
>
>

 you forgot two thinks:
> CREATE OR REPLACE FUNCTION char2num (charnum in varchar2) RETURN number IS
> i number;
> digits number;
> current_digit char(1);
> parsechar varchar2(2000); -- you need a length value for this type

> BEGIN
> parsechar :='';
> digits := length(charnum);
> for i in 1..digits loop
> current_digit := SUBSTR(charnum, i, 1);
> if current_digit in ('0','1','2','3','4','5','6','7','8','9') then
> parsechar := parsechar || current_digit;
-- you need an end for an if-clause

       end if;
> end loop;
> return to_number(parsechar);
> END char2num;

best regards

                 Teoman Ayan