Re: function as default constraint for column

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_at_perceptron.com">ineyman_at_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_at_MetraTech.com
  href="mailto:Harvinder.Singh_at_MetraTech.com">Harvinder Singh To: <A title=ORACLE-L_at_fatcity.com href="mailto:ORACLE-L_at_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 Received on Fri Aug 03 2001 - 15:16:05 CDT