Try to change your table definition of the column from varchar2 to char,
then you will be allowed to put empty space into oracle.
-----Original Message-----
From: Fannin, David P. [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 07, 2001 1:53 PM
To: '[EMAIL PROTECTED]'
Subject: DBD::Oracle -- bind variables treat string of spaces as NULL
I've got an application where I need to use bind variables to populate many
tables of a reporting server nightly. I'm using DBD::Oracle to access the
target server. If I use $sth->bind_param ($num, ' ') Oracle treats the
string of spaces as a NULL in my insert statement. Since NULLS aren't
allowed but spaces are, I really need a solution. At this point, the only
that does work is going through the following loop:
# fetch the data
$qry = "insert into blah ('$col1', '$col2', '$col3');
#prepare and execute
Obviously this is much slower than using bind variables. Truly, I have
tried everything I can think of and could use some help. Any suggestions?
Thanks!
-dpf-
-----------------------
David P. Fannin
Database Administrator [EMAIL PROTECTED]
UM-Rolla Computing and Information Services FAX (573) 341-4216
URL http://www.umr.edu/~dpf PHONE (573) 341-4841
-----------------------
