Help with conversions (suite)

Hello everybody.

I have a little problem.

Where I make a
select to_number('123456.789','000000.00') or select
to_number('123456.789','000000D00')
I obtain 123456.78

When I try to make that in a function, I have a varchar in ligne.temp8 (ex:
'123456.78910')
temp_dr_cli_cod := to_number(ligne.temp8,''000000000'');

That is good (without decimals of course), but when I try to add a dot or a
'D' in the format field (ex : temp_dr_cli_cod :=
to_number(ligne.temp8,''000000.000'') or temp_dr_cli_cod :=
to_number(ligne.temp8,''000000D000'') I get a error message :
ERROR: parser: parse error at or near "000000".

Can someone help me ?

Thanks a lot.

Regards,
Stéphane.