Oracle Links

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.
 
L

Lynn Trapp

Have your Oracle DBA put an On Insert trigger on the table that selects the
..nextval of the sequence.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert Record into Oracle Table 1
Format DATETIME to Date in query on linked table 4
Append Query w/sequence.NextVal to Oracle DB? 2
Appending large recordset from Oracle Linked table 1
Using Passthrough Query to Disable Triggers 4
Access Append Query to update Sequence Generator in Oracle 9
Poor performance running queries with tables linked to Oracle Back 4
Weird characters in query results 1

Top