Stack Overflow
Stack Overflow

Questions tagged [oracleexception]

21 questions
24
votes
8 answers

ORA-03113: end-of-file on communication channel after long inactivity in ASP.Net app

I've got a load-balanced (not using Session state) ASP.Net 2.0 app on IIS5 running back to a single Oracle 10g server, using version 10.1.0.301 of the ODAC/ODP.Net drivers. After a long period of inactivity (a few hours), the application, seemingly…
Greg Hurlman
  • 17,666
  • 6
  • 54
  • 86
8
votes
3 answers

Error when trying to connect to Oracle 10g database from C# program employing minimal set-up configuration

I'm experiencing an error when trying to connect to a remote Oracle 10g database from a C# 2008 Express Edition application I'm developing. I'm trying to use a minimalist, non-intrusive approach to the development with a view to ClickOnce deployment…
steve
  • 137
  • 1
  • 2
  • 10
3
votes
2 answers

Oracle DataAccess Data provider internal error -3000 when deployed

I'm having an issue with a web service i have created. It is running fine when running on localhost on my PC. The problem is, when I deploy the web service to a remote IIS server, I keep getting "Data provider internal error(-3000)". It always…
SpaceCowboy74
  • 1,367
  • 1
  • 23
  • 46
2
votes
1 answer

Serialize and Deserialize Oracle.DataAccess.OracleException in C#

OracleException has no public constructors nor any way to get a new instance. I tried my XmlSerializerHelper class, but it requires a public parameterless constructor. I used BinaryFormatter to serialize the OracleException and wrote it to a file. …
Kiquenet
  • 14,494
  • 35
  • 148
  • 243
2
votes
1 answer

Oracle.DataAccess.Client.OracleException C#

I have this class where I am selecting two values from the database and comparing it to the textbox values provided by the users. Below is my class. public void Userlogin(TextBox username, TextBox pwd) { int _failedAttempt = 0; …
user4113185
1
vote
0 answers

How to add database name to Oracle error?

I am copying some data via DB link from a remote DB (let's call it DB A) to another DB (DB B). If any errors occur then I catch them and write them to a table like this: EXCEPTION WHEN OTHERS THEN BEGIN INSERT INTO T_ERROR(....,…
Dinu Nicolae
  • 1,019
  • 2
  • 17
  • 42
1
vote
2 answers

So how is `ROLLBACK` in Oracle exception handler different from my `ROLLBACK`?

How Oracle Database rollback to the beginning of the PL/SQL block, but not the earlier DML instructions (I think all this come under one single transaction). Because when I try to ROLLBACK creating an exception handler all the instructions until…
sql_dummy
  • 715
  • 8
  • 23
1
vote
0 answers

Throw OracleException in odp.net 4

How can I throw OracleException in odp.net 4? These methods... throw new OracleException(); // or with error number throw new OracleException(1013); ...do not work.
alexhutsau
  • 98
  • 2
  • 7
1
vote
2 answers

How to raise an OracleException for test purposes

I have a function that executes some SQL commands, and I've created a logger that I write in the file the command that was executed and the number of rows that were affected, but I also need to write down the command that may have raised an…
LikeIfYouCaredAboutMyName
  • 67
  • 12
1
vote
1 answer

How do I create an instance of Oracle.DataAccess.Client.OracleException to use with NMock

I'm using the Oracle.DataAccess.Client data provider client. I am having trouble constructing a new instance of an OracleException object, but it keeps telling me that there are no public constructors. I saw other having the same problem and tried…
Charles Crawford
  • 61
  • 3
0
votes
1 answer

How to dynamically get column that triggered OracleException

If I have ORA-12899 returned from an insert or update statement. How can I extract the column name from the OracleException without parsing the string? ORA-12899: value too large for column "SCHEMA"."TABLENAME"."COLUMNNAME" (actual: 175, maximum:…
Silvia Tomescu
  • 1
0
votes
2 answers

Sqlerrm() vs Sqlcode()

as Sqlerrm() returns message and code which is provided by orecle. exception 1: like for in implicit cursor when data not found error ouccers n we are writing exception handling like dbms_ou..(sqlerrm()); output: ORA-01403: no data found and for…
harsha lohana
  • 25
  • 6
0
votes
1 answer

How to check if the exception is an Oracle exception?

I want to handle any Oracle Db Exception on Application level.Hence written following piece of code in Application_Error function of Global.asax The code seems to be more specific but i want to write code for any kind of Oracle Exception. protected…
SantyEssac
  • 789
  • 2
  • 19
  • 47
0
votes
1 answer

ArrayOutOfBoundException and OracleXAException (XAException.XAER_RMFAIL) exceptions

I am using Oracle Database 11g Release 11.2.0.4.0 - 64bit database and WildFly 8.2.0 Application Server. I am using managed connection in our application and XA transactions. When I try to execute a query that is very complex (number of parameters…
user140888
  • 609
  • 1
  • 11
  • 31
0
votes
1 answer

OracleException with respect to Connection issues or Database down

Say I have following query private void updateusers() { List listRecords=new List(); string strQuery="select * from table where role='Admin' and logged_in<=sysdate-1"; OracleCommand com=new…
Guruprasad J Rao
  • 29,410
  • 14
  • 101
  • 200
1
2