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

•  
      Console.WriteLine("{0} row have been inserted", rows);
      con.Close();
      con.Dispose();
    }
  }

  
  See Also:

  "ArrayBindIndex" for more information

   

  OracleParameterStatus Enumeration Types
  Table: OracleParameterStatus Members lists OracleParameterStatus enumeration values.

  
  OracleParameterStatus Members

  Member Names
  Description

  Success
  For input parameters, indicates that the input value has been assigned to the column.

  For output parameters, indicates that the provider assigned an intact value to the parameter.

  NullFetched
  Indicates that a NULL value has been fetched from a column or an OUT parameter.

  NullInsert
  Indicates that a NULL value is to be inserted into a column.

  Truncation
  Indicates that truncation has occurred when fetching the data from the column.

   

  Statement Caching
  Statement caching eliminates the need to parse each SQL or PL/SQL statement before execution by caching server cursors created during the initial statement execution. Subsequent executions of the same statement can reuse the parsed information from the cursor, and then execute the statement without reparsing, for better performance.

  In order to see performance gains from statement caching, Oracle recommends caching only those statements that will be repeatedly executed. Furthermore, SQL or PL/SQL statements should use parameters rather than literal values. Doing so takes full advantage of statement caching, because parsed information from parameterized statements can be reused even if the parameter values change in subsequent executions. However, if the literal values in the statements are different, the parsed information cannot be reused unless the subsequent statements also have the same literal values.

  
  

• 上一页 [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

特别推荐