Click here to Skip to main content
15,885,856 members
Home / Discussions / C#
   

C#

 
GeneralRe: Problem with MdiParent-MdiChildren forms Pin
Nine_31-May-09 21:12
Nine_31-May-09 21:12 
GeneralRe: Problem with MdiParent-MdiChildren forms Pin
dan!sh 31-May-09 21:23
professional dan!sh 31-May-09 21:23 
GeneralRe: Problem with MdiParent-MdiChildren forms Pin
Nine_31-May-09 21:29
Nine_31-May-09 21:29 
QuestionHow to delete the URL from cache entry in c#? Pin
svt gdwl31-May-09 20:31
svt gdwl31-May-09 20:31 
QuestionDataGridView Pin
Yathish hatter31-May-09 20:19
Yathish hatter31-May-09 20:19 
AnswerRe: DataGridView Pin
Satish Pai31-May-09 20:29
Satish Pai31-May-09 20:29 
GeneralRe: DataGridView Pin
Yathish hatter1-Jun-09 18:43
Yathish hatter1-Jun-09 18:43 
Questionfacing problem with C# ODP.Net API(Oracle.DataAccess.dll) "Open cursors exceeded" exception is occured Pin
member12345631-May-09 19:33
member12345631-May-09 19:33 
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.
QuestionTCP Server Question *IMPORTANT* Pin
Serpendiem31-May-09 18:30
Serpendiem31-May-09 18:30 
AnswerRe: TCP Server Question *IMPORTANT* Pin
Jimmanuel1-Jun-09 2:45
Jimmanuel1-Jun-09 2:45 
Question[SOLVED] Future or past date time Pin
CodingLover31-May-09 18:02
CodingLover31-May-09 18:02 
AnswerRe: Future or past date time Pin
CodingLover31-May-09 18:05
CodingLover31-May-09 18:05 
QuestionBelow idea how to be realized in C#? Pin
mctramp16831-May-09 17:08
mctramp16831-May-09 17:08 
AnswerRe: Below idea how to be realized in C#? Pin
Christian Graus31-May-09 19:25
protectorChristian Graus31-May-09 19:25 
GeneralRe: Below idea how to be realized in C#? Pin
mctramp16831-May-09 20:13
mctramp16831-May-09 20:13 
GeneralRe: Below idea how to be realized in C#? Pin
Christian Graus31-May-09 21:48
protectorChristian Graus31-May-09 21:48 
GeneralRe: Below idea how to be realized in C#? Pin
mctramp16831-May-09 22:04
mctramp16831-May-09 22:04 
GeneralRe: Below idea how to be realized in C#? Pin
Pete O'Hanlon31-May-09 22:19
mvePete O'Hanlon31-May-09 22:19 
GeneralRe: Below idea how to be realized in C#? Pin
0x3c01-Jun-09 0:07
0x3c01-Jun-09 0:07 
GeneralRe: Below idea how to be realized in C#? Pin
mctramp1681-Jun-09 1:16
mctramp1681-Jun-09 1:16 
Questioncustom control textbox with a label tied Pin
Wendell.S31-May-09 16:21
Wendell.S31-May-09 16:21 
AnswerRe: custom control textbox with a label tied Pin
Dave Kreskowiak31-May-09 17:28
mveDave Kreskowiak31-May-09 17:28 
QuestionUltra-light native embedded database Pin
Pascal Ganaye31-May-09 10:27
Pascal Ganaye31-May-09 10:27 
AnswerRe: Ultra-light native embedded database Pin
Henry Minute31-May-09 11:07
Henry Minute31-May-09 11:07 
AnswerRe: Ultra-light native embedded database Pin
Garth J Lancaster31-May-09 12:02
professionalGarth J Lancaster31-May-09 12:02 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.