Check OracleClob Parameter Value is null

Posted: December 7, 2011 in .Net
Tags: ,

Sharing a small tip here.If you want to check whether the OracleClob Parameter value from database is null or not and assign value,make use of the IsNull property as below.

if (!((OracleClob)(command.Parameters[2].Value)).IsNull)
{
OracleClob clob = (OracleClob)command.Parameters[2].Value;
}

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s