OraFAQ Forum: Windows » How to pass null values in OracleCommand as a parameters

Home » Infrastructure » Windows » How to pass null values in OracleCommand as a parameters (Oracle 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to pass null values in OracleCommand as a parameters [message #561127]

Thu, 19 July 2012 01:20

shmessage
Messages: 5
Registered: July 2012

Junior Member

How to pass null values in OracleCommand as a parameters

i am doing like this
((OracleCommand)cmdMySql).Parameters.Add(":1" ,Varchar2).Value = DBNull.Value;

Its giving error when dataadapter is going to fill.

Report message to a moderator

Re: How to pass null values in OracleCommand as a parameters [message #561136 is a reply to message #561127]

Thu, 19 July 2012 01:31

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Which language is this?

Regards
Michel

Report message to a moderator

Re: How to pass null values in OracleCommand as a parameters [message #561138 is a reply to message #561136]

Thu, 19 July 2012 01:32

shmessage
Messages: 5
Registered: July 2012

Junior Member

Asp.net with c#

Report message to a moderator

Re: How to pass null values in OracleCommand as a parameters [message #561143 is a reply to message #561138]

Thu, 19 July 2012 01:35

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I move the topic to the appropriate forum.

Regards
Michel

Report message to a moderator

Previous Topic:	Any Easier Way?
Next Topic:	SQLLDR

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 11 15:06:04 CST 2024