SQL execute

  • Thread starter Thread starter davel
  • Start date Start date
D

davel

Is it possible to run an Oracle stored procedure from
Access VB with an ODBC or ADO connection?
We have some idea of the statements used inADO but we're
lacking how to logon to the Oracle database.

Thak you
Dave
 
Thank you for the site but, still not a clue. I don't know
what I'm looking for.
Simply, I'm currently accessing an Oracle database through
an Access Form (DRIVER={Microsoft ODBC for Oracle)). This
will not recognize an "Execute" command to a stored
procedure in the database. What is the VB script that will
connect to the database and run the Execute cmd?

Thank you
-----Original Message-----
Check Carl Prothman's http://www.able-
Click to expand...
consulting.com/ado_conn.htm for the
 
I know of no way of passing parameters from Access to pass-through queries, but
if you do not need to pass any parameters, a pass-through query with 'Returns
records' set to No should do this.

If you do need parameters, one work-around that I have used is to create an
Oracle table and call the procedure of function from an update trigger. This
table can then be linked to Access as with any other. You may need to take
care to allow for multiple users with this approach though. I do so by
checking the value of one of the columns and then waiting until it is not
marked as being in use, you could also have multiple rows present for each
value of CurrentUser (assuming that you are using Access security).

John
 
Back
Top