oracle+select+自定义,c#select查询到Oracle数据库抛出“自定义类型映射...未指定或无效”...

我正试图在我的c#应用程序中映射一个简单的Oracle UDT。当我尝试从DataReader提取数据时，它会引发以下异常：

Custom type mapping for 'dataSource='DB' schemaName='C##LAZAR'

typeName='MATICNIBROJ_T'' is not specified or is invalid

Oracle UDT是：

create or replace

TYPE "MATICNIBROJ_T" AS OBJECT (

MaticniBroj NUMBER(13)

)

INSTANTIABLE NOT FINAL用于映射的自定义类：

[OracleCustomTypeMapping("C##LAZAR.MATICNIBROJ_T")]

public class MaticniBrojT : IOracleCustomType

{

[OracleObjectMappingAttribute("MaticniBroj")]

public virtual int MaticniBroj { get; set; }

//c# custom type --> Oracle UDT

public virtual void FromCustomObject(OracleConnection conn, IntPtr obj)

{

OracleUdt.SetValue(conn, obj, "MaticniBroj", this.MaticniBroj);

}

//Oracle UDT --> c# custom type

public virtual void ToCustomObject(OracleConnection conn, IntPtr obj)

{

this.MaticniBroj = ((int)(OracleUdt.GetValue(conn, obj, "MaticniBroj")));

}

}数据库通讯：

string upit = @"SELECT PIB, NAZIV, RACUN, FAX, TELEFON, ADRESA, EMAIL,

MATICNIBR FROM KOMITENT_VW k WHERE UPPER(NAZIV) LIKE '%" + naziv.ToUpper() + "%'";

conn = napraviKonekciju();

conn.Open();

OracleCommand cmd = new OracleCommand();

cmd.Connection = conn;

cmd.CommandText = upit;

cmd.CommandType = CommandType.Text;

OracleDataReader dr = cmd.ExecuteReader();

DataSet ds = new DataSet();

DataTable dt = new DataTable();

dt.Columns.Add("PIB");

dt.Columns.Add("NAZIV");

dt.Columns.Add("RACUN");

dt.Columns.Add("FAX");

dt.Columns.Add("TELEFON");

dt.Columns.Add("ADRESA");

dt.Columns.Add("EMAIL");

dt.Columns.Add("MATICNIBR");

ds.Tables.Add(dt);

while(dr.Read())

{

DataRow red = dt.NewRow();

red["PIB"] = dr.GetInt32(0);

red["NAZIV"] = dr.GetString(1);

red["RACUN"] = dr.GetString(2);

red["FAX"] = dr.GetString(3);

red["TELEFON"] = dr.GetString(4);

red["ADRESA"] = dr.GetString(5);

red["EMAIL"] = dr.GetString(6);

//----next line throws an exception

MaticniBrojT mBroj = (MaticniBrojT)dr.GetValue(7);

red["MATICNIBR"] = Convert.ToInt64(mBroj.MaticniBroj);

}

return ds;

}

catch (Exception ex)

{

return null;

}

finally

{

conn.Close();

conn.Dispose();

conn = null;

}大部分代码由用户LSA提供。虽然这些错误是我的。

有人能澄清我出错的地方吗？