Re: calling procedures from access
Date: 2000/07/04
Message-ID: <962685443.12911.3.pluto.d4ee154e_at_news.demon.nl>#1/1
Use begin <stored procedure name>; end;
instead of execute <stored procedure name>
Actually the execute is a sql*plus wrapper.
Hth,
Sybrand Bakker, Oracle DBA
"CHUCK BECK" <ctb_at_PRODIGY.NET> wrote in message
news:8jrjlc$5gkc$1_at_newssvr04-int.news.prodigy.com...
>
> Hello all,
> hope this isn't too off topic for this list.
> I am trying to create an Access application with an Oracle back end. I
need
> Access to call some stored Oracle procedures but I do not know the syntax.
> I have tried using the SQL pass through with no success. I can pass
regular
> SQL statements ok, but not the PL/SQL call. In Oracle you call the
> procedure with 'execute procedure name'. It does work correctly on the
> oracle side.
> Is there some kind of qualifying statement that needs to precede the
oracle
> statement? Any ideas or places to look for info would be appreciated.
>
> Chuck
>
>
Received on Tue Jul 04 2000 - 00:00:00 CEST