C#´¦Àíoracle lobµÄÀý×Ó
	
    
    
	  protected void BindData1()
    {
        OracleConnection orcn = new OracleConnection("User ID=wesoftwcp; Password=wesoft; Data Source=oradb");
        orcn.Open();
        string MyData = "";
        StreamReader rs = new StreamReader(@"c:\1.txt");
        MyData = rs.ReadToEnd();
        rs.Close();
        //OracleConnection orcn = new OracleConnection("User ID=wesoftwcp; Password=wesoft; Data Source=oradb");
        //orcn.Open();
        OracleType lobtype = OracleType.Clob; //Èç¹ûÊÇblobÕâÀï¸Ä³ÉOracleType.blob
        string CreateTempBlob = "DECLARE A " + lobtype + "; " +
            "BEGIN " +
            "DBMS_LOB.CREATETEMPORARY(A, FALSE); " +
            ":LOC := A; " +
            "END;";
        OracleTransaction transaction = orcn.BeginTransaction();
        OracleParameter[] param = new OracleParameter[1];
        param[0] = new OracleParameter("LOC", OracleType.Clob);
        //OracleHelper.CacheParameter(CreateTempBlob,param);
        OracleCommand cmdTemp = new OracleCommand(CreateTempBlob, orcn);
        param[0].Direction = ParameterDirection.Output;
        //OracleHelper.ExecuteNonQuery(transaction
    
     
	
	
    
    
	Ïà¹ØÎĵµ£º
        
    
    ÔÚORACLE8Öж¨ÒåÁË£º±êÁ¿(Scalar)¡¢¸´ºÏ(COMPOSITE)¡¢ÒýÓÃ(REFERENCE)ºÍLOBËÄÖÖÊý¾ÝÀàÐÍ¡£
£¨Ò»£©±êÁ¿(Scalar)
    ±êÁ¿ÀàÐÍÓëÊý¾Ý¿âµÄÁÐËùʹÓõÄÀàÐÍÏàͬ£¬´ËÍâËü»¹ÓÐһЩÀ©Õ¹¡£ 
    ËüÓÖ·ÖΪÆß¸ö×飺Êý×Ö¡¢×Ö·û¡¢ÐС¢ÈÕÆÚ¡¢Ðбêʶ¡¢²¼¶ûºÍ¿ÉÐÅ¡£ 
¢ÙÊý×Ö
¡¡
    ÓÐÈ ......
	
    
        
    
    ѧϰOracleʱ£¬Äã¿ÉÄÜ»áÓöµ½OracleÓû§±í¿Õ¼äÎÊÌ⣬ÕâÀォ½éÉÜOracleÓû§±í¿Õ¼äÎÊÌâµÄ½â¾ö·½·¨£¬ÔÚÕâÀïÄóöÀ´ºÍ´ó¼Ò·ÖÏíһϡ£Æäʵ¾ÍÊÇÔÚÒÑÓеÄÊý¾Ý¿âʵÀýÉÏ´´½¨Ò»¸öеÄÕʺţ¬·ÃÎÊһЩÐÂµÄ±í¡£
²Ù×÷²½ÖèÈçÏ£º
1¡¢µÇ¼linux£¬ÒÔOracleÓû§µÇ¼£¨Èç¹ûÊÇrootÓû§µÇ¼µÄ£¬µÇ¼ºóÓÃsu-oracleÃüÁîÇл»³ÉoracleÓû§£©
2¡¢ÒÔsy ......
	
    
        
    
    
Êý¾Ý¿â½á¹¹ºÍ¿Õ¼ä¹ÜÀí£¨Êý¾ÝÎļþ¡¢ÈÕÖ¾Îļþ¡¢±í¿Õ¼ä¡¢¶Î¡¢Ä£Ê½ºÍģʽ¶ÔÏó£© 
   Ò»¸öORACLEÊý¾Ý¿âÊÇÊý¾ÝµÄ¼¯ºÏ,±»´¦Àí³ÉÒ»¸öµ¥Î»¡£Ò»¸öORACLEÊý¾Ý¿âÓÐÒ»¸öÎïÀí½á¹¹ºÍÒ»¸öÂß¼½á¹¹¡£
   ORACLEÂß¼Êý¾Ý¿â½á¹¹ÊÇÓû§ËùÉæ¼°µÄÊý¾Ý¿â½á¹¹¡£Ò»¸öORACLEÊý¾Ý¿âµÄÂß¼½á¹¹ÓÉÏÂÁÐÒòËØ¾ö¶¨:
  &nb ......
	
    
        
    
    oracleÖеÄBLOB×Ö¶ÎÊÇ´æ´¢2½øÖƵÄÎļþ£¬±ÈÈçÎļþ£¬Í¼Æ¬µÈ¡£
1¡¢°Ñ±¾µØÎļþдÈëÊý¾Ý¿â
package com.data;
import java.io.File;
import java.io.FileInputStream;
import java.io.OutputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.R ......
	
    
        
    
    ϵͳҪÇó£º
¡¡¡¡ÄÚ´æ£ºÍÆ¼ö1G
¡¡¡¡Swap·ÖÇø£ºÉèΪÄÚ´æµÄ2±¶
¡¡¡¡/tmp´ÅÅ̿ռ䣺400MBÒÔÉÏÈý
¡¡¡¡´ÅÅ̿ռ䣺Èí¼þ3.5G Êý¾Ý1.2G
¡¡¡¡ËùÐèÈí¼þ£º
¡¡¡¡SuSE Linux10 for x86
¡¡¡¡Oracle database 10gR2 for Linux32
¡¡¡¡Orarun-1.8-109.15.i586.rpmÈí¼þ°ü£¬¿ÉÒÔ´Óhttp://Ftp.novell.com/partners/Oracle/sels-9ÏÂÔØ
&n ......