Re: Converting Longs

From: <Jared.Still_at_radisys.com>
Date: Wed, 24 Jul 2002 11:16:17 -0800
Message-ID: <F001.004A14FD.20020724111617@fatcity.com>

Depending on whether you wish to humiliate and demoralize the duhveloper, or you think there may be hope and you wish to educate him, one of the following may work.

1. Show him the the sys.trigger$ table and point him at documentation that will help him convert the WHENCLAUSE column to a CLOB
2. Privately point out to him that this is part of the data dictionary, and that making changes to this will likely cause him grief and anxiety such as he has never known.

Jared

"Jay" <fish_dba_at_hotmail.com>
Sent by: root_at_fatcity.com
07/23/2002 07:23 PM
Please respond to ORACLE-L  

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        Converting Longs

Hello:
Since everyone has forwarded a comment about their war stories I would like
to offer up my Monday.
The a programmer on a client I am working at asked me to convert all of the
long data types since Oracle recommends that you do not use them. Since we use no longs I asked what he was referring to. He said please run
a DESC on ALL_TRIGGERS, Then commented that I do not know my database.

ALTER SYSTEM DROP STUPID_USER user does not seem to be working in this situation any ideas?
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Jay
  INET: fish_dba_at_hotmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
  INET: Jared.Still_at_radisys.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Jul 24 2002 - 14:16:17 CDT