The exception tag has no wiki summary.
2
votes
2answers
35 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
...
1
vote
1answer
56 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 ...
5
votes
2answers
245 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
1answer
131 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
...
0
votes
0answers
294 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 ...
2
votes
1answer
77 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,
...
3
votes
2answers
505 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
...
3
votes
2answers
2k 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 ...
