Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

nls_numeric_character - what's wrong?

Roger25May 15 2013 — edited May 15 2013
Hi,
I have set for my current session:

ALTER SESSION SET NLS_NUMERIC_CHARACTERS = ",.";

Then why the following block gives me an error
declare
  test_tip_data NUMBER := 67568,8;
begin
  dbms_output.put_line(test_tip_data);
end;
 
ORA-06550: line 3, column 32:
PLS-00103: Encountered the symbol "," when expecting one of the following:

   * & = - + ; < / > at in is mod remainder not rem
   <an exponent (**)> <> or != or ~= >= <= <> and or like like2
   like4 likec between || multiset member submultiset
The symbol "* was inserted before "," to continue.
{code}
?

Shouldn't the output be 67.568,8 ? (the separator for the thounsands is ".")?

Thanks.

Edited by: Roger25 on 15.05.2013 16:10                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 12 2013
Added on May 15 2013
12 comments
724 views