Re: How to bind a null value while using insert statements

[Andrew Dunstan]

Harpreet Dhaliwal wrote:

Hi,

I have the following insert statement

insert into abc (a,b,c) values (?,?,?);

when i execute this insert (in perl) i get the following error

Cannot bind a reference (ARRAY(0x925069c)) ((null))

This is because value of column a is defined but null
So how should in bind null value in my insert statement?

For a null value you pass undef - see the DBI docs.

cheers

andrew