asp.net with oracle connectivity issue

Question

I am trying to add parameters using oracle as database using the following code :

for (int i = 1; i <= count; i++)
{
    var parameterName = ":ref_cur" + i;
    DbParameter parameter = Acidaes.Data.DbHelper.CreateRefCursorParameter(
        parameterName, 
        ParameterDirection.Output);
    command.Parameters.Add(parameter);
}

Following Crash occurs while adding parameters

[A]Oracle.DataAccess.Client.OracleParameter cannot be cast to [B]Oracle.DataAccess.Client.OracleParameter. Type A originates from 'Oracle.DataAccess, Version=2.112.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342' in the context 'Default' at location 'C:\WINDOWS\assembly\GAC_32\Oracle.DataAccess\2.112.2.0__89b483f429c47342\Oracle.DataAccess.dll'. Type B originates from 'Oracle.DataAccess, Version=4.112.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342' in the context 'Default' at location 'C:\WINDOWS\Microsoft.Net\assembly\GAC_32\Oracle.DataAccess\v4.0_4.112.2.0__89b483f429c47342\Oracle.DataAccess.dll'.

Didn't find way to resolve this crash.

Paddy · Accepted Answer · 2013-03-04 12:37:12Z

4

You need to check your references, there is a mismatch in the versions you are looking at:

DbParameter parameter = 
 Acidaes.Data.DbHelper.CreateRefCursorParameter(parameterName, ParameterDirection.Output);

DbParameter as referenced in your code is not of the same type (version in this case) as what is being returned from your DbHelper class. You will need to update these two projects to refer to the same version of Oracle.DataAccess.

answered Mar 4, 2013 at 12:37

Paddy

34k15 gold badges82 silver badges121 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Paddy Over a year ago

No worries - if you hit the tick at the side of the answer, it will let people know that this answer was 'correct'.

Collectives™ on Stack Overflow

asp.net with oracle connectivity issue

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related