The exception tag has no wiki summary.
8
votes
2answers
12k views
How to catch and handle only specific Oracle exceptions?
From this and this i guess, that there is no predefined Named System Exceptions for ORA-00955.
How can I rewrite the following to catch only the error ORA-00955?
begin
EXECUTE IMMEDIATE ...
5
votes
2answers
889 views
One Complex Stored Procedure Causes Estimated Cost Exception
In SQL Server, I'm getting the following error "The query has been canceled because the estimated cost of this query (5822) exceeds the configured threshold of 300. Contact the system administrator."
...
3
votes
2answers
401 views
Can stable (or immutable) functions call volatile functions?
The PostgreSQL documentation states:
Any function with side-effects must be labeled VOLATILE...
Consider the following function:
CREATE OR REPLACE FUNCTION count_items()
RETURNS integer AS
...
3
votes
1answer
299 views
An inconsistency in SQL Server 2008 R2
(could be) possible duplicate with An inconsistency was detected
I have small table that returns from query
UDA-SQL-0114 The cursor supplied to the operation "sqlOpenResult" is
...
3
votes
3answers
102 views
How to raise_application_error beyond a when others clause
Background:
I've used a few Oracle articles to develop an error package, with some procedures. One of these is Log_And_Return which is called throughout the database. I've simplified it for brevity, ...
3
votes
2answers
2k views
Why Sqlcode 100 does not come with exception
I have following query in a PL\SQL procedure on Oracle 10.2:
This is the code
LOOP
BEGIN
SELECT a.poid_id0 into v_acc_account_poidid0
FROM account_t a
WHERE a.poid_id0=i_acct_id0
...
2
votes
1answer
478 views
Is it possible to raiserror within a For Delete Trigger that rolls back the deletes
There is a claim at the end of this accepted answer that if an error occurs within a "For Delete" trigger, the delete action would be rolled back because it is part of an implicit transaction.
...
2
votes
1answer
153 views
PLSQL Package - Catching Errors in procedure (Oracle)
I have a problem with my package (and procedure) not catching exceptions.
I have the below code:
CREATE OR REPLACE PACKAGE process_orders
IS
PROCEDURE add_order (
order_num NUMBER,
...
2
votes
1answer
235 views
INSERT trigger dying with with #target columns not equal to #expressions, but they are equal
I am trying to write my first trigger. It is an insert trigger as follows:
<b>Fatal error</b>: postgres7 error: [-1: ERROR: INSERT has more target columns than expressions at character ...
2
votes
0answers
256 views
SSMS causing Event ID 4674: SeTakeOwnershipPrivilege
Somewhat of a strange one. Recently my user id's been showing up in a number of Audit Success records in the Security event log of one of our production database servers with the below content (or ...
1
vote
1answer
196 views
Using EXCEPTION to ignore duplicates during bulk inserts
In pq 9.3.5, I'm importing records from an external source where duplicates are VERY rare, but they do happen. Given a readings table with a unique compound key on (real_time_device_id, recorded_at), ...
1
vote
1answer
407 views
exception: hosts cannot switch between localhost and hostname
I created a replication set.
I added localhost in the set in the beginning, but when I try to edit the member with the actual hostname. I get error "exception: hosts cannot switch between localhost ...
1
vote
0answers
51 views
ORA-01861 - Input seems ok and FX/FM modifiers not used
Using SQL Developer 4, I am getting an ORA-01861 exception when I do the following (and BTW, I ticked 'Ignore NLS Definitions'):
alter session set nls_date_format = 'DD-MON-YY';
alter session set ...
1
vote
1answer
464 views
MongoDB Shard - Disable Cursor timeout
I'm using an sharded-cluster(Mongo version 2.4.1) with a java application. After a specific time (10 minutes or more) I got the following exception:
com.mongodb.MongoException$Network: Read operation ...
1
vote
0answers
1k views
Does MySQL close cursor if stored procedure encounters an exception?
I've seen two different approaches of cursor handling is MySQL stored procedures. Now I'm curious about their stability, due to potential MYSQLEXCEPTION risks in stored routines.
Assuming, that ...
0
votes
1answer
307 views
Is using dbms_utility.format_error_stack to filter errors in the exception block a bad idea?
I'm trying to handle two different exceptions could trigger in an external table that reads a CSV.
The code works great, but I'm concerned I'm doing it wrong.
SET SERVEROUTPUT ON;
DECLARE
records ...
0
votes
0answers
194 views
Configuration to stop mysql sleep
I am trying to configure a mariadb / mysql instance to stop sleeping when there is no activity for a while. The reason being is that I keep getting the following exception in my java logs when nobody ...
0
votes
1answer
167 views
MySQL add few column exception for TRIGGER UPDATE FOR EACH ROW
How to effectively add column id, name exception for trigger:
CREATE TRIGGER updated BEFORE UPDATE ON table1 FOR EACH ROW SET NEW.date=NOW()
so that date=NOW() will be affected on updating any ...
0
votes
0answers
245 views
Exception in SQL client but not in stored procedure
I am using Oracle 11g and SQLDeveloper for this scenario. In this scenario, I am trying to simulate an exception within a stored procedure but it is not happening. My DB runs in GMT. My client ...
0
votes
1answer
2k views
Cassandra: Request did not complete within rpc_timeout
i was working with Cassandra 1.2.4 probably, after restoring some key-space when i tried to query in a key-space it gave me Request did not complete within rpc_timeout
so i checked system.log & ...
0
votes
0answers
671 views
Sybase ASA 9 Central exception on connecting to old database
I have installed sybase ASA 9 i used the sybase central to connect to an old version .db file of ASA version 6, a wizard popup and ask yes or no to unload the database .. for upgrade i click yes ...
-1
votes
1answer
38 views
System.Data.SqlClient.SqlException when try to run simply queries
I've installed SQL Server 2012 Express. I'm doing some test with this and Server 2008 Express.
With 2008, all is ok. But with the 2012, I get some troubles.
I'm using it from my c# app, with code ...
