exec Oracle stored proc

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

Guest

In Access 97 I used to be able to put an Oracle EXEC
statement in the body of a pass-through query; now when I
do that I either get an ODBC error or no error but the
proc has not executed.

Is there a setting I need (in Access or in ODBC admin) to
be able to truly pass through native server commands and
not have Access/ODBC interpret them?
 
I don't use Oracle but the first thing I would check is
the [ODBC Connection Str] for the Pass-Through Query.

Create a simple Pass-Through (Select Query) with the [ODBC
Connection Str] and see if it works OK.

HTH
Van T. Dinh
MVP (Access)
 
Back
Top