How to save null values to blob field in database

[anandmms]

Hello friends,

I am having a table Personal_Detail, and in that table i am having some fields like name, id, phone_number etc... and also with two blob fields photo1, photo2(allow null).

my condition is to save two photos, one(photo1) is must and another one(photo2) is optional...
when i am passing null value to the optional field i got the exception
ORA-01008: not all variables bound

I am using C# window application and
database - oracle

I cannot rectify the problem, could any one tell how to insert null values to bolb field in database.

thanks in advance
regards
anand

[SvenV]

What does your query look like?

[anandmms]

What does your query look like?

OracleCommand cmd  = new OracleCommand("insert into personal(idno, firstphoto, secondphoto) values (:id, :first, :second)", con);
            cmd.Parameters.Add(":id", OracleType.VarChar);
            cmd.Parameters.Add(":first", OracleType.Blob);
            cmd.Parameters.Add(":second", OracleType.Blob);
            cmd.Parameters[0].Value=txt_Idno.Text;
            cmd.Parameters[1].Value=photo1;
            cmd.Parameters[1].Value = photo2;

//Already having one image in byte array photo1;
//photo2 is null;

when i execute this querry i got the exception
so how to insert the field photo2 with null value;

[viknesh]

To insert null value into blob field using bind variable,
say my oracleparameter is blobparam,
set null value by

blobparam=DBNull.Value