| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Oracle procedures
Hello,
My name is Jules and I am programming Access for some months now.
I must design an multi user application in Access 2.0 with tables on Oracle 7.0(SQL SERVER IN WIN NT). It is supposed to keep track of inventories of 3 locations. Oracle contains (among others) a "ORDERS" (one-side) main tabel and a "ORDERSINFO"(many-side) sub table in which subrecords (orders) are placed. For users to place orders I was thinking of a Main/sub Form relationship that fills records in local Access tables from which Oracle Tables are updated.
How can I use Oracle in this construction? Can I refer to my local Access tables from an Oracle procedure? The "ORDERS" table must have a SEQUENCER, and the subrecords for "ORDERINFO" must get the same value from the SEQUENCER(pk for "ORDERINFO" is ordernr/produktnr). Do I write a trigger for this and if so what would it look like?
Further do user schema's relate to updates or SEQUENCE values and in what way?
Hope you got some answers...
Greetings from Holland.
P.S. Leave the "NoSPAM-1261" thing out of my adress to react.
Posted using Reference.COM http://WWW.Reference.COMFREE Usenet and Mailing list archive, directory and clipping service
 |
 |