RSS

Ora-1036

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.
Advertisements
 
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:

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

 
%d bloggers like this: