Access to Oracle using 'Commit'

[Mark Day]

Hi all,
I am running some sql from Access 2000 to an existing Oracle 8i database
using the "INSERT INTO 'connection string for Oracle' etc etc. then the
docmd.runSQL which works fine. However I then have to open the Oracle SQL
Plus program and type 'commit' to finally commit the changes. I would like
to automate this last step from within Access. ie commit the Oracle changes
from within Access VB. Can this be achieved? If so can anyone be kind enough
to give me a quick syntax example.

TIA
Mark Day.

 

[Dejan]

Hi!

I have spoken to somebody who does Oracle with Access and
they told me that they do not do Commit when updating
Oracle tables from Access. They said the data is not
lost, it gets Commited, but probably not immediattely.

They recomanded writing Oracle stored procedure (on
Oracle side) which would have two parts - UPDATE part and
Commit. Then, form Access you use pass through to invoke
the stored procedure.