From ineyman@perceptron.com Fri, 03 Aug 2001 13:16:05 -0700
From: "Igor Neyman" <ineyman@perceptron.com>
Date: Fri, 03 Aug 2001 13:16:05 -0700
Subject: Re: function as default constraint for column
Message-ID: <F001.0036036C.20010803130145@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain



No, it's not possible - use 'before' trigger.
I think, I read you can use function as default in 
9i.
 
Igor Neyman, OCP DBAPerceptron, Inc.(734)414-4627<A 
href="mailto:ineyman@perceptron.com">ineyman@perceptron.com  

<BLOCKQUOTE dir=ltr 
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
  ----- Original Message ----- 
  <DIV 
  style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: 
  <A title=Harvinder.Singh@MetraTech.com 
  href="mailto:Harvinder.Singh@MetraTech.com">Harvinder Singh 
  To: <A title=ORACLE-L@fatcity.com 
  href="mailto:ORACLE-L@fatcity.com">Multiple recipients of list ORACLE-L 
  
  Sent: Friday, August 03, 2001 3:32 
  PM
  Subject: function as default constraint 
  for column
  
  HI,
  I have a function which does some manipulation on date and i want to put 
  that function as
  default value for coulmn. But i am getting error :
  alter table dd modify(dd date default getutcdate())
  *
  ERROR at line 1:
  ORA-04044: procedure, function, package, or type is not allowed here
  Can it be possible to define function as default value..if not some other 
  way to define this.....execpt trigger......
  Function does not have any IN paramter defined.
  Thanks
  Harvinder