I'm trying to insert rows containing empty strings into a table using placeholders and bind_param.
According to my understanding of the DBI documentation, bind_param should treat undef as null-values but null-values should be substituted as empty strings.
However, I'm getting errors like below:
DBD::Oracle::st execute failed: ORA-01400: cannot insert NULL into ("BERGOLTH"."ABTEILUNG"."NAME_EN") (DBD ERROR: OCIStmtExecute) [for statement ``INSERT INTO abteilung (tid, name, name_en, kurzbez, fk_institut)
VALUES (?, ?, ?, ?, ?)'' with params: :p5='21', :p3='', :p1='22', :p4='-----', :p2='E xx2 (keine)']) at ./import.pl line 89.
(p3 is '', not undef!)
Any hints? --leo
P.S.: I'm using Fedora Core 1, Oracle 9.2.0 and > rpm -q perl perl-DBI perl-DBD-Oracle perl-5.8.3-16 perl-DBI-1.37-1 perl-DBD-Oracle-1.14-1
-- ------------------------------------------------------- Alexander (Leo) Bergolth [EMAIL PROTECTED] WU-Wien - Zentrum fuer Informatikdienste - Projektbuero
