CREATE DIRECTORY XMLDIR AS 'C:\';
GRANT READ ON DIRECTORY XMLDIR TO PUBLIC;

Insert into resumes2 values (1,
　　XMLType(bfilename('XMLDIR','test.xml'),nls_charset_id('AL16UTF8')));
  我发现这种方法里XMLDIR路径指向的是服务器目录，而我希望这个目录是客户端的目录，我该怎样修改呢？？
  我是不是需要把xml文件先存入clob，然后再insert呢?在.net中应该怎么来做，是不是需要安装Oracle Data Provider for .Net？？我下载了一个，一安装界面就不动了，晕呢，知道的朋友能解答一下吗，万分感谢！！

第一步：将xml文件读成string型：
StreamReader sr = new StreamReader("E:\\my.net\\oracleXmlTest\\mcc.xml");
  string outstring = "";
                // Read and display lines from the file until the end of
                // the file is reached.
             while ((line = sr.ReadLine()) != null)
             {
                 outstring += line;
             }
或者直接：
  XmlDocument xDocument = new XmlDocument();
  xDocument.Load("E:\\my.net\\oracleXmlTest\\mcc.xml");
第二步：定义OracleXmlType
     // OracleXmlType cxml = new OracleXmlType(conn, outstring);
       OracleXmlType cxml = new OracleXmlType(conn, xDocument);
第三步：
OracleConnection conn = new OracleConnection("Data Source=GISORA;User

Id=meng;Password=meng");
conn.Open();
OracleCommand cmd = new OracleCommand();
cmd.Connection = conn;
cmd.CommandText = "INSERT INTO resumes4 VALUES (15,:pb)";
cmd.Parameters.Add("pb", OracleDbType.XmlType, iSize).Value = cxml;
cmd.ExecuteNonQuery();            
conn.Close();
代码很简单,过程很艰难!