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" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/23/2002 07:23 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
