随笔分类 -  C#

调用oralce的procedure时如何传入table类型数据[网上资料]
摘要：前端时间有个项目，需要调用oracle存储过程，他的传入参数中有自定义的table类型的数据。解决方法如下：1、需要安装oracle对应的ODPPL/SQL Package : My PackCREATE PACKAGE MYPACK ASTYPE AssocArrayVarchar2_t is table of VARCHAR(20) index by BINARY_INTEGER;PROCEDURE TestVarchar2( Param1 IN AssocArrayVarchar2_t, Param2 IN OUT AssocArrayVarchar2_t, Param3 OUT As. 阅读全文
posted @ 2011-03-09 09:30 mythzz 阅读(545) 评论(0) 推荐(0)
castle配置数据库连接问题
摘要：castle 官方文档太郁闷了IDictionary<string, string> properties = new Dictionary<string, string>(); //sqlserver properties.Add("connection.driver_class", "NHibernate.Driver.SqlClientDriver"); properties.Add("dialect", "NHibernate.Dialect.MsSql2008Dialect"); 阅读全文
posted @ 2011-02-21 17:25 mythzz 阅读(737) 评论(0) 推荐(0)