Home » Open Source » Programming Interfaces » insert into db via perl dbi (11gr2)
insert into db via perl dbi [message #640993] Sat, 08 August 2015 09:37 Go to previous message
hudo
Messages: 165
Registered: May 2004
Senior Member
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
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Locked individual records only for individual users on MS ACCESS
Next Topic: How to get SELECT columns size with Perl DBI+DBD::Oracle?
Goto Forum:
  


Current Time: Fri May 10 00:20:34 CDT 2024