Home -> Usenet -> comp.databases.oracle -> Mutating table

Mutating table

From: Matt Houseman <mhouseman_at_inprise.com>
Date: Mon, 21 Dec 1998 11:22:42 -0800
Message-ID: <367EA002.62432081_at_inprise.com> 





All,



I'm attempting to load information from a spreadsheet that contains many
columns; one of which is a phone number.  In the source data, the phone
number is either 'UNKNOWN' or the actual phone number.  The requirement
from the user community is to set the phone number to
'UNKNOWN_<seq_num>' on insert if the source data is 'UNKNOWN'.  It seems
to me that any trigger that I write will cause a mutating table error.
Does anyone know a method by which this can be accomplished?  Thanks in
advance...



Matt Houseman
Received on Mon Dec 21 1998 - 20:22:42 CET












Original text of this message