No, it's not possible - use 'before' trigger.
I think, I read you can use function as default in
9i.
----- Original Message -----
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
|