RE: last column in a table is added with a DEFAULT

[Mercadante, Thomas F]

Title: RE: last column in a table is added with a DEFAULT

David,

 

Nope.  Your programmer is wrong.

 

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
From: Ehresmann, David [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 07, 2003 3:09 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: last column in a table is added with a DEFAULT

I understand that part.  What the programmer is saying that you can not add the last column to a table with a default value.  Does that sound reasonable?

thanks, Raj.

David.

-----Original Message-----
From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 07, 2003 1:25 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: last column in a table is added with a DEFAULT

as soon as you add a column all depending code goes invalid, the dependency checking process doesn't discriminate about the default value.

Raj
--------------------------------------------------------------------------------
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !

-----Original Message-----
From: Ehresmann, David [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 07, 2003 1:09 PM
To: Multiple recipients of list ORACLE-L
Subject: last column in a table is added with a DEFAULT

Has anybody ever heard of this?  I have a developer saying this is an oracle
bug.  It caused some packages to go invalid.

"The error seems to be related to a bug in oracle caused when the last
column in a table is added with a default."

David Ehresmann 

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ehresmann, David
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).