RE: Who Says Oracle does not listen

2003-07-22 Thread Igor Neyman
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.

RE: Who Says Oracle does not listen

2003-07-22 Thread Alexander . Feinstein
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

RE: Who Says Oracle does not listen

2003-07-22 Thread Igor Neyman
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

RE: Who Says Oracle does not listen

2003-07-22 Thread Jacques Kilchoer
-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

RE: Who Says Oracle does not listen

2003-07-22 Thread Jacques Kilchoer
-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 listen

2003-07-21 Thread Alex Feinstein
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

RE: Who Says Oracle does not listen

2003-07-18 Thread Igor Neyman
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 =

RE: Who Says Oracle does not listen

2003-07-18 Thread Goulet, Dick
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

RE: Who Says Oracle does not listen

2003-07-18 Thread Igor Neyman
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]

RE: Who Says Oracle does not listen

2003-07-18 Thread Alexander . Feinstein
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