Developer technologies | C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
Update table in Oracle using ExecuteNonQuery is giving exception Oracle exception- Network session: end of file.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 96%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECV%3C/text%3E%3C/svg%3E)
Chandran, Vinitha
40
Reputation points
I was trying to create a C# console application to execute the Oracle package.
I was able to establish the connection successfully and using Execute Scalar i can be able to select the set of data from the same table using some inline query.
But for executing the package/ executing simple inline update query, i am facing issue. Once ExecuteNonQuery statement executed. the application is not responding and it not moving to next line of code. Also, my update query is not reflecting in Oracle table too.
After long waiting (20 mints) i am getting Oracle exception- Network session: end of file.
Please share any solution if you have same experience.
Thanks
Developer technologies | C#
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous2023-11-17T09:43:07.45+00:00 Hi @Chandran, Vinitha , Welcome to Microsoft Q&A,
Could you please share your target code? Maybe the problem is with the code.
Does it work when operating directly on the database? Maybe the problem is with your database.
-
Chandran, Vinitha 40 Reputation points
2023-11-17T13:33:48.8933333+00:00 Hi @Jiale Xue , Thank you for Response.
Direct execution in Database it is working fine. Issue facing once hitted in ExecuteNonquerry.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(6.4, 79%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK0%3C/text%3E%3C/svg%3E)
KOZ6.0 6,735 Reputation points2023-11-17T18:00:41.96+00:00 Are you using ODP.NET?
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 65%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPS%3C/text%3E%3C/svg%3E)
Philip Stuyck 1 Reputation point2023-11-20T14:23:28.57+00:00 You do know that you should parameterize your query. Like it is now using string concatenation to insert the values is asking for problems in the long run. Other than that you should use executequery because it is not a stored procedure and the result is normally the number of records updated or inserted.
Sign in to comment
Sign in to answer