Oracle Links

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Access database that has links to an Oracle database with several
tables. The Oracle tables have a required field that is autonumbered.
(sequentially numbered using nextval) I am trying to append several records
to that table. How would I write the query in access to append the records
from an access table to an Oracle table and inserting the next sequential
number in Oracle to the mandatory field in the Oracle table since that value
is not stored in my access table? Any help would be greatly appreciated.
 
Have your Oracle DBA put an On Insert trigger on the table that selects the
..nextval of the sequence.
 
Back
Top