I am using the C# API to insert a xml file which is having schemaLocation attribute in it. from the database side, we are using ODP.Net provider for oracle 10g. ODP.Net is having full support in case of xml native functionalities and we are using non-structured xml type of storage. Problem: "Open cursors exceeded" exception is coming when importing more than 300 xml files into xmltype(Oracle) field with ODP.Net provider(Oracle.DataAccess.dll) using the relevant C# API for that.(I have Disposed all the resources using here). here is the sample code: string strFileContents = strXmlRecordContent; if (Conn == null) { Conn = new Oracle.DataAccess.Client.OracleConnection(CatalogueDbConnection.ConnectionString); } if (Conn.State != ConnectionState.Open) { Conn.Open(); } Oracle.DataAccess.Client.OracleCommand cmdInsertXmlRec = new Oracle.DataAccess.Client.OracleCommand(); cmdInsertXmlRec.Connection = Conn; cmdInsertXmlRec.CommandText = "INSERT INTO XMLRecord (MetadataID,XMLData) VALUES(:Metadataid,:strFileContents ) "; cmdInsertXmlRec.Parameters.Add(":Metadataid", Oracle.DataAccess.Client.OracleDbType.Int32).Value = MetadataID; OracleXmlType Text = new OracleXmlType(Conn, doc); cmdInsertXmlRec.Parameters.Add(":strFileContents", Oracle.DataAccess.Client.OracleDbType.XmlType).Value = Text; cmdInsertXmlRec.ExecuteNonQuery(); if (cmdInsertXmlRec != null) cmdInsertXmlRec.Dispose(); one main observation: cursors are opened if the xml file is having schemaLoaction attribute in it.

Hi, we have a method written in C# having the two dimensional string array as an argument. in case of VB,two dimensional string array has not supported.so how can we make use of the functionality of this method from the VB clients. Thanks in advance.

[Message Deleted]

Hi All, I have a doubt in C# XML update Operation. while inserting/Updating/Deleting the node in XML ,I need to validate the xml with the corresponding Schema definition.Can you provide the solution without using the normal schema validation mechanism using C#.because every time while updating the node the normal validation mechanism takes more time for validating entire record.