INSERT trigger question..

I am trying to determine if the proper method of doing this would be an insert trigger or hard coding into the application level.

I have some web based forms that are processed and stored in Oracle 816. One of the objects in Oracle is a simple table consisting of several columns, one of which is a primary key of type number. I have a sequence that increments by 1. I want each new record to store the next value into the primary key column. Can an insert trigger be used in this manner. ie: All other column data will be inserted by an sqlnet call, but I want the primary key column to be inserted into by an insert trigger.

Or, would the best method be to simply call the sequence next value and then insert everything from the application.

Thanks in advance,
Chuck Received on Mon Dec 18 2000 - 14:15:33 CST