Hello,
I'm having problems inserting values into db via perl dbi. My NLS_LANGUAGE is german.
The table column is NUMBER(8,2), the delivered data is e.g 1234,56 or 0,00
My code is like
my $stora_insert_article = $dbora->prepare(
q{INSERT INTO ARTIKEL (
PF0
, PF1
)
VALUES (
TO_NUMBER(?, '9999D99' , 'NLS_NUMERIC_CHARACTERS=,.')
,TO_NUMBER(?, '9999D99' , 'NLS_NUMERIC_CHARACTERS=,.')
)
});
The error message is like
Quote:
DBD::Oracle::st execute failed: ORA-01722: invalid number (DBD ERROR: error poss