passing Oracle Nulls in ADO.NET

[Craig G]

how do you pass a null into an oracle parameter?

i am doing the following which works fine when there is data to be passed in
but when the string is blank it wont accept "" or even as a system.dbnull

'Parameter for Address1

Dim parAddress1 As OracleClient.OracleParameter

parAddress1 = cmdInsert.Parameters.Add("strAddress1",
OracleClient.OracleType.VarChar)

parAddress1.Direction = ParameterDirection.Input

parAddress1.Value = Strings.UCase(strAddress1)

if have tried doing something like this

If strAddress1 = "" Then

parAddress1.Value = myDBNull (which is simply a variable as type
system.dbnull)

end if

but still no joy

Cheers,
Craig

[Craig G]

sorry guys wrong forum!!!
"Craig G" <craig.gamble@y_arrasoftware.com> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...

how do you pass a null into an oracle parameter?

i am doing the following which works fine when there is data to be passed in but when the string is blank it wont accept "" or even as a system.dbnull

'Parameter for Address1

Dim parAddress1 As OracleClient.OracleParameter

parAddress1 = cmdInsert.Parameters.Add("strAddress1",
OracleClient.OracleType.VarChar)

parAddress1.Direction = ParameterDirection.Input

parAddress1.Value = Strings.UCase(strAddress1)

if have tried doing something like this

If strAddress1 = "" Then

parAddress1.Value = myDBNull (which is simply a variable as type
system.dbnull)

end if

but still no joy

Cheers,
Craig