.NET调用Oracle存储过程，使用数组类型的参数(如ArrayList)

•     prm.Value = myArrayDeptNo;
   
      // Add the parameter to the parameter collection
      cmd.Parameters.Add(prm);
   
      // Execute the command
  
      cmd.ExecuteNonQuery();
      Console.WriteLine("Insert Completed Successfully");
   
      // Close and Dispose OracleConnection object
      con.Close();
      con.Dispose();
    }
  }

  
  See Also:

  "Value" for more information

  
  OracleParameter Array Bind Properties
  The OracleParameter class provides two properties for granular control when using the array bind feature:

  ArrayBindSize

  The ArrayBindSize property is an array of integers specifying the maximum size for each corresponding value in an array. The ArrayBindSize property is similar to the Size property of an OracleParameter object, except the ArrayBindSize property specifies the size for each value in an array.

  Before the execution, the application must populate the ArrayBindSize property; after the execution, ODP.NET populates it.

  The ArrayBindSize property is used only for parameter types that have variable length such as Clob, Blob, and Varchar2. The size is represented in bytes for binary datatypes, and characters for the Unicode string types. The count for string types does not include the terminating character. The size is inferred from the actual size of the value, if it is not eXPlicitly set. For an output parameter, the size of each value is set by ODP.NET. The ArrayBindSize property is ignored for fixed-length datatypes.

  ArrayBindStatus

  The ArrayBindStatus property is an array of OracleParameterStatus values that specify the status of each corresponding value in an array for a parameter. This property is similar to the Status property of the OracleParameter object, except that the ArrayBindStatus property specifies the status for each array value.

  Before the execution, the application must populate the ArrayBindStatus property. After the execution, ODP.NET populates the property. Before the execution, an application using the ArrayBindStatus property can specify a NULL value for the corresponding element in the array for a parameter. After the execution, ODP.NET populates the ArrayBindStatus property, indicating whether the corresponding element in the array has a null value, or if data truncation occurred when the value was fetched.

  
  

• 上一页 [1] [2] [3] [4] [5] [6] [7] 下一页 
• 复制本页网址和标题，发送给你QQ/Msn的好友一起分享
  
  
• .NET调用Oracle存储过程，使用数组类型的参数(如ArrayList) 相关文章：
• ·Excel XP函数实用教程精华集
• ·ASP函数库
• ·轻松了解MySQL数据库中的CONVERT（）
• ·在Excel中将文本转换为数字的七种方法
• ·关于oracle日期函数的介绍和使用
• ·图片保存到数据库和从数据库读取图片并显示(c#)
• ·数据库连接字符串大全
• ·ASP.NET中数据库的操作初步----增加、删除、修改
• ·UDT协议-基于UDP的可靠数据传输协议
• ·oracle函数之常见单行字符串函数
• .NET调用Oracle存储过程，使用数组类型的参数(如ArrayList) 相关软件
• ·DataExplore数据恢复大师 V2.5
• ·数据结构与算法
• ·我有数备份专家(免引导盘GHOST) V1.6.1 绿色版
• ·小学数学伴侣 V5.0
• ·MathType 数学公式编辑器 V5.2 汉化版
• ·P8数字娱乐传播平台 V1.0.1.55
• ·数字小键盘指法练习 V1.2
• ·初中数学课件大全 V1.0
• ·数谜(Kakuro Quest)
• ·数码宝贝2

上一篇:ASP.NET之上传文件管理策略

下一篇:DataTable操作中的性能问题

• 特别声明：本站除部分特别声明禁止转载的专稿外的其他文章可以自由转载，但请务必注明出处和原始作
• 者.文章版权归文章原始作者所有.对于被本站转载文章的个人和网站，我们表示深深的谢意。如果本站转
• 载的文章有版权问题请联系编辑人员,我们尽快予以更正. 转载请注明来源：http://www.hackhome.com

精品推荐

热点TOP10

特别推荐