14 Feb

The Ora-1036 exception pops out frequently when one learning ADO.NET with Oracle database. Here are a couple reasons of the exception which I myself have experienced:

  1. The parameters’ name, type or amount doesn’t match the ones in the CommandText.
  2. When using the same SqlCommand/OraCommand more than once, forget to clear the ParameterCollection in the command.
Leave a comment

Posted by on February 14, 2012 in .NET, SQL


Leave a Reply

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

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

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s

%d bloggers like this: