Access/Oracle Stored procedures?

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. Received on Wed Jul 10 1996 - 00:00:00 CEST