ora存、查clob类型帮助文档.txt

 //Oracle类 
        public static OracleCommand cmd = null;
        public static OracleConnection conn = null;
        public static string constr = @"Data Source=(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 数据库ip地址)(PORT = 1521)) )
                                  (CONNECT_DATA =(SERVICE_NAME=数据库别名自定义)) );User Id=;Password=;";
        #region Oracle帮助类
        /// <returns>返回一个数据库连接的OracleConnection对象</returns>   
        public static OracleConnection Connec()
        {
            try
            {
                conn = new OracleConnection(constr); //connstr ： 数据库链接字符串
                if (conn.State != ConnectionState.Open)
                {
                    conn.Open();
                }
            }
            catch (Exception e)
            {
                throw new Exception(e.Message.ToString());
            }
            return conn;
        }
        public static int ExecuteNonQuery(string cmdText, string clobs2)
        {
            int count;
            try
            {
                Connec();
                cmd = new OracleCommand(cmdText, conn);