Re: Calling a stored procedure from an insert statement

Or using the Oracle provided sequence feature (as mentioned by Sybrand):

insert into my_table
values (sequence_name.nextval, col1, col2, sysdate, .... )

Or using a before insert trigger
select sequence_name.nextval into v_key from sys.dual :new.key := v_key;

HTH -- Mark D Powell -- Received on Sun Mar 26 2006 - 17:20:18 CST