DBD::Oracle inserts null if the value of the bind parameter is undef.
Therefore if you have a scalar which is undef it will insert as null, other
time when it has a value it will insert the actual value. You must use
placeholders though. See docs.
Ilya
-----Original Message-----
From: Edd Dawson
To: [EMAIL PROTECTED]
Sent: 06/19/2001 9:32 AM
Subject: Oracle and nulls
Hi,
I am trying to insert a record into an oracle database, and i need to
insert leave some of the fields null, but other time's I may need to
insert data into those fields within the same script. Does anyone
have any ideas how I might achieve the null business?
thanks very much
Edd Dawson
------------------------------
Edd Dawson
Senior Analyst Programmer
University of Derby
+44 0(1332) 591239
[EMAIL PROTECTED]
------------------------------
