Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Calling Stored Procedures from Access 97

Calling Stored Procedures from Access 97

From: Stefan Jahnke <sjahnke_at_tkc.de>
Date: 1998/11/09
Message-ID: <36471813.C9098CE@tkc.de>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US