Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Calling Stored Procedures from Access 97
Hi,
I have a bunch of stored procedures in an Oracle 7.3 database. Now I have to call them directly from Access 97. How does this work ? I tried to rewrite some procedures as functions and call the function from a view, then select the view from Access (really not a convenient solution).Additionally, it won't work for most of the procedures, because data is being updated, so I couldn't call them from a view. Besides this, I tried SQL-Pass-Through, but it doesn't support EXECUTE, afaik.
HELP !?!?
TIA
Stefan
Received on Mon Nov 09 1998 - 00:00:00 CST
![]() |
![]() |