Doing it my way just seems to be cleaner: why forcing exception, when
it could be avoided?
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Alex Feinstein
Sent: Tuesday, July 22, 2003 1:44 AM
To: Multiple recipients of list ORACLE-L
RE: Who Says Oracle does not listenAgree.
Title: RE: Who Says Oracle does not listen
Performance.
You do check, and the DBMS does check internally.
Alex.
-Original Message-
From: Igor Neyman [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 22, 2003 6:34 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Who Says
Title: RE: Who Says Oracle does not listen
In this case performance is not an issue.
I dont drop/create/modify
tables/columns/synonyms every minute. The script runs, when we install new
release of our product, happens once in a few months.
Igor Neyman, OCP DBA
[EMAIL PROTECTED
-Original Message-
From: Igor Neyman [mailto:[EMAIL PROTECTED]
In this case performance is not an issue.
I don't drop/create/modify tables/columns/synonyms every minute.
The script runs, when we install new release of our product,
happens once in a few months.
I hear what you're
-Original Message-
From: Igor Neyman [mailto:[EMAIL PROTECTED]
In this case performance is not an issue.
I don't drop/create/modify tables/columns/synonyms every minute.
The script runs, when we install new release of our product,
happens once in a few months.
oops! Forgot the
RE: Who Says Oracle does not listenAgree.
One can improve EXCEPTION section to ignore only relevant errors.
Alex.
- Original Message -
To: Multiple recipients of list ORACLE-L
Sent: Monday, July 21, 2003 6:19 AM
That's not good enough.
I don't want to discard ANY exception.
When
To avoid those errors in my scripts I'm checking data dictionary for the
existence of the object (fortunately, dynamic sql helps here):
REM Dropping synonym
DECLARE lCounter integer;
begin
SELECT COUNT(*) INTO lSyn
FROM dba_synonyms WHERE synonym_name = 'PRCPV_REPORT_INFO' AND
OWNER =
Igor,
True enough, but wouldn't you like it as part and parcel of the command?
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Friday, July 18, 2003 4:35 PM
To: Multiple recipients of list ORACLE-L
To avoid those errors in my scripts I'm
Sure, I would.
But I can't wait till Oracle turns around.
My scripts are executed by our field engineers, who know next to
nothing about Oracle, and the only thing they can do is to check log
files for error messages (and even this is done automatically).
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
Title: RE: Who Says Oracle does not listen
From ORACLE own script:
Rem
Rem Drop tables without raising errors if they do not exist
Rem
declare
PROCEDURE drop_force(tab varchar2) IS
BEGIN
EXECUTE IMMEDIATE 'DROP TABLE ' || tab;
EXCEPTION WHEN OTHERS THEN
NULL;
END;
begin
drop_force
10 matches
Mail list logo