Character Conversion question

[mahali]

Hi there,

I have just discovered a strange effect, maybe one of you has an explanation: there is a select-statement in a pl/sql-procedure where there is a multiplication of a number and a varchar2-value and, which works perfectly well. If I copy the select-statement and execute it "stand-alone" I am getting the error-message "Invalid number", because of the fact that there is a '.' as decimal separator in the varchar2 field insteas of a ','.
So my question now is if the implicit conversion is handled differently in oracle, depending on the "location" of the statement.

I hope this is not too confusing..???

Thank you very much in advance,
Mahali

 

[Dagon]

It may be related to your NLS settings. If you're using a comma in place of a decimal point, you must have some region-specific settings.

 

[SantaMufasa]

Mahali,

Could you please post the offending code?

Mahalo.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]