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 -> Re: Access app running an oracle stored procedure?

Re: Access app running an oracle stored procedure?

From: Mike Hackett <sharmike_at_voicenet.com>
Date: 1997/09/30
Message-ID: <60s31c$2kt$1@news3.voicenet.com>#1/1

In your passthrough query try enclosing the procedure call in an anonymous PL/SQL block.
If tou have a procedure named MY_PROC that takes a number parameter, try something like this:

begin my_proc(1234); end;

>I am trying to run an oracle stored procedure from an access application
>and I am not having any luck. I am trying to run it as a pass through
>query. Does anyone have
>any sugestions?
>
>lellwyn_at_wei.org
>
>L. Ellwyn
Received on Tue Sep 30 1997 - 00:00:00 CDT

Original text of this message

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