21 questions
0
votes
2
answers
2k
views
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(...
1
vote
0
answers
57
views
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 ...
- 1,331
1
vote
2
answers
3k
views
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 ...
- 783
1
vote
0
answers
156
views
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.
- 138
2
votes
1
answer
6k
views
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, ...
user4113185
0
votes
1
answer
933
views
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 ...
- 809
1
vote
2
answers
3k
views
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 ...
0
votes
1
answer
616
views
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 ...
- 609
0
votes
1
answer
87
views
OracleException with respect to Connection issues or Database down
Say I have following query
private void updateusers()
{
List<int> listRecords=new List<int>();
string strQuery="select * from table where role='Admin' and logged_in<=sysdate-1";...
- 29.7k
0
votes
1
answer
159
views
Execution stops after SQLERRM
I don't know if it is strange or not, but the execution stops/exits just after first encounter of SQLERRM.
I need to saved the exception details into the table made for the same.
Below is the code:
...
- 1,003
0
votes
1
answer
104
views
Why doesn't Oracle throw an error here
I'm looking at a script I didn't write here. and it looks something like this:
SELECT
...
AND (
A.FIELD IN
(
...
...
)
OR B.FIELD IN
(
...
...
- 5,049
0
votes
1
answer
633
views
Determine Type of PL/SQL Exception
In an OTHERS exception block I'd like to display the type of exception.
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE( -- I want to display the type of exception here -- );
END;
- 8,164
0
votes
1
answer
175
views
How to Handle Exceptions like DB down In Stored procedure
I am archiving data from one table to another table using below procedure.
create or replace PROCEDURE CHECK_TWO AS
v_insert_count number;
v_delete_count number;
v_initial_count number;
BEGIN
...
- 189
0
votes
3
answers
546
views
Oracle - should I use exceptions or triggers?
When trying to insert data into tables, it could fail for various reasons like unique key violated or foreign key violated.
I could use DUP_VAL_ON_INDEX exception to know unique key is violated but ...
- 194
0
votes
1
answer
3k
views
Oracle: Error while registering Oracle JDBC Diagnosability MBean
I am trying to install OracleClient 11g and initially i had a issue regarding JDK compatibility.
Error:
so i ended up uninstalling JDK 7 (64bit) and reinstalled JDK 6 (32bit) and edited sqldeveloper....
- 4,709
8
votes
3
answers
11k
views
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 ...
- 147
0
votes
1
answer
311
views
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"....
2
votes
1
answer
1k
views
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 ...
- 15.2k
3
votes
2
answers
6k
views
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 "...
- 1,431
1
vote
1
answer
524
views
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....
23
votes
8
answers
210k
views
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 ...
- 17.8k