Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÔÚÏߵȸßÊÖ£¬150·îÉÏ£¬OracleдclobÎÊÌ⣬°ï¶¥ÓзÖ

http://topic.csdn.net/u/20091015/11/5f41b718-7918-4992-8795-2cccc5e957e8.html?seed=1756713731&r=60435954#r_60435954

µÈ¼¶²»¹»Ö»ÄÜ·¢100·Ö£¬ÉÏÃæÕâ¸öÌù»¹ÓÐ50·Ö¡£

²»Ëµ·Ï»°ÁË£¬Çë¿´´úÂ룬ÎÊÌâ¾ÍÊÇÏÂÃæµÄ×¢ÊÍ´¦
C# code:

string sql = @"select POINT_SET from WELLBORE_LOG where ID='1' For Update";
OracleConnection oraOc = new OracleConnection("Integrated Security=no;User ID=ADMIN;Data Source=MyBASE;Password=ADMIN");
oraOc.Open();
OracleCommand ocmd = new OracleCommand(sql, oraOc);
OracleDataReader oraReader = ocmd.ExecuteReader();
using (oraReader)
{
if (oraReader.HasRows)
{
oraReader.Read();
OracleLob clob = oraReader.GetOracleLob(0);

//ÕâÀïµÃµ½µÄclob.Connection ×ÜÊÇΪnull£¬·Ç³£ÈÃÈËÓôÃÆ£¬ÈçºÎ½â¾ö
if (clob.Connection != null && clob != OracleLob.Null)
{
clob.Write(bytes, 0, bytes.Length);
}
clob.Position = 0;
ocmd.Transaction.Commit();
}
}



²»»á Oracle£¬½¨Òé LZ µ½ Oracle ×¨ÇøÈ¥ÎÊÎÊ¿´£º
http://forum.csdn.net/SList/Oracle_Develop

clobÔ


Ïà¹ØÎÊ´ð£º

linux + oracleÓÃXP·ÃÎʲ»ÁË

ÎÒ°²×°Ò»Ì¨redhat linux5+oracle 10gµÄ·þÎñÆ÷£¬±Ê¼Ç±¾£¨XPϵͳ£©°²×°ÁËoracle 10g¿Í»§¶Ë,½á¹ûÀÏÊdzö12560µÄ´íÎó£¬Çë¸ßÊÖÖ¸µãÒ»¶þ£¬

-A RH-Firewall-1-INPUT -m state –state NEW -m tcp -p tcp –dpor ......

PHP Á¬½ÓOracle ³ö´í

<?php
  getenv("ORACLE_HOME");
  $conn=ocilogon("test","test","test_db");
  if($conn)  
  echo success;  
&nb ......

½éÉÜOracleºÍmysqlµÄÊé - Oracle / ·Ç¼¼ÊõÇø

ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......

ÖªµÀÔõô°Ñsasµ¼ÈëoracleµÄ½øÀ´¿´¿´

ÎÒÏÖÔÚÓÐһЩsasÉÏÃæµÄÊý¾ÝÎļþ ÏÖÔÚÎÒÐèÒª°Ñsasµ¼Èëµ½oracle
ÏÖÔÚ°ÑÒ»¸ösasÎļþµ¼Èëµ½Ò»¸öoracleÖеÄÒ»¸ö±íÖÐÎÒÒѾ­ÖªµÀÔõôŪÁË
µ«ÊÇ ÎÒÏÖÔÚÐèÒª°ÑsasÖеÄÁíÒ»¸öÎļþ×·¼Óµ½oracleÖеÄÒ»¸öÓÐÊý¾ÝµÄÒ»¸ö±íÉÏà ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ