Re: Access/Oracle Stored procedures?

"Raul P. Murguia" <murguia_at_mail.utexas.edu> wrote:

::>I am designing a form in Access that allows the user to query
::>a remote Oracle table. I build an SQL query from the text boxes
::>that the user fills out. Unfortunately, the query is too slow
::>right now.
 

::>I am vaguely familiar with the concept of stored procedures. Could
::>they help speed up the app?
 

::>Are there any good books on how to call a procedure from Access
::>& how to code it on the Oracle db?
 

::>Any help would be appreciated.
 

::>Thanks.

If my experience with SQL Server stored procedures is of any indication, then I'd say you're on the right track, the improvment is markedly noticeable.

The TechNet discusses the means of building the code for a SP using an ODBC driver as transport media.

I've found that the easier and more efficient way of dealing with SP is to have built on the server side and use Access as a front end (Pass-Through Query).

Sol. Received on Thu Jul 25 1996 - 00:00:00 CEST